Power BI DAX: Show Selected Scenario While Always Displaying Baseline (Blank) Rows

Question

In PowerBi, I have a table called Events and a ScenarioSlicerTable. I want the user to be able choose which Scenario to display, but I also want to always display rows where Scenario is blank. These are baseline rows.

I’ve tried this code, but the SelectedValue function always returns blank for me.

If (ISBLANK(Events[Scenario]),
TRUE(),
Events[Scenario]=SELECTEDVALUE(ScenarioSlicerTable[Scenario])

I know I could always have a multi select slicer and just beg the user to select blank and one other scenario, but that’s not very professional

Sample Data

Events Table

EventID	EventName	Scenario
1	Event A
2	Event B	Scenario 1
3	Event C	Scenario 2
4	Event D
5	Event E	Scenario 1

ScenarioSlicerTable

Scenario
Scenario 1
Scenario 2

Expected Output when "Scenario 1" is selected

EventID	EventName	Scenario
1	Event A
4	Event D
2	Event B	Scenario 1
5	Event E	Scenario 1

DAX Attempted

If (ISBLANK(Events[Scenario]),
    TRUE(),
    Events[Scenario] = SELECTEDVALUE(ScenarioSlicerTable[Scenario])
)

could you pls provide some sample data and expected output?

Ryan
– Ryan

2025-05-15 08:25:11 +00:00
Commented May 15 at 8:25 — Ryan
– Ryan, Commented May 15 at 8:25
@Ryan added example

Jack
– Jack

2025-05-15 08:31:31 +00:00
Commented May 15 at 8:31 — Jack
– Jack, Commented May 15 at 8:31

Ryan · Accepted Answer · 2025-05-16 00:42:12Z

0

try NOT to create relationship between two tables.

if it's always a single selection, you can try to create a measure

Measure =
IF (
    MAX ( 'Event'[Scenario] ) = MAX ( 'ScenarioSlicer'[Scenario] )
        || MAX ( Event[Scenario] ) = "",
    1
)

and add the measure to visual filter and set to 1

if you want a multiple selection, you can update the measure to

MEASURE 2 =
VAR _list =
    DISTINCT ( 'ScenarioSlicer'[Scenario] )
RETURN
    IF ( MAX ( Event[Scenario] ) IN _list || MAX ( Event[Scenario] ) = "", 1 )

answered May 16 at 0:42

Ryan

2,6891 gold badge2 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jack May 16 at 3:28

this works in a table, but is there a way to get it to work in a bar chart also? I want to display some visuals for my data.

Jack May 16 at 3:34

With your solution, the slicer seems to only work for Scenario 2 in a bar chart

Ryan May 16 at 8:12

could you pls paste the expected bar chart screenshot ?

Collectives™ on Stack Overflow

Power BI DAX: Show Selected Scenario While Always Displaying Baseline (Blank) Rows

Sample Data

Expected Output when "Scenario 1" is selected

DAX Attempted

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Sample Data

Expected Output when "Scenario 1" is selected

DAX Attempted

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related