Dynamic text based on multiple slicers

[hellojb]

I have a text card that changes the values based on slicers selected. 

if there are no filters, the text says x 

if a slicer is filtered, text says y.

What I am struggling with is how to change the text dynamically if more than one slicers (columns) are filtered.

[v-jianboli-msft · Accepted solution]

Hi @hellojb ,

Based on your description, I have creeated a simple sample:

I created two slicers:

Try the measure:

Measure = IF( SELECTEDVALUE('Table'[Column1])=BLANK()&&SELECTEDVALUE('Table (2)'[Column1])=BLANK(),"x","y")

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@hellojb See if this helps: The Most Amazing, Mind Blowing Dynamic Slicer Titl... - Microsoft Power BI Community

[Abhilash_P]

Hello @hellojb ,

You can use below dax function

IF(DISTINCTCOUNT(Table[Column]) > 1,CONCATENATEX(VALUES(Table[Column]),(Table[Column]),"-"),SELECTEDVALUE(Table[Column]))

[hellojb]

what about if there are mutiple columns filtered?

[Abhilash_P]

U can use 

CONCATENATE DAX function and combine the values from multiple columns

Regards