Forum Discussion
Dynamic text based on multiple slicers
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.
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.
5 Replies
Hello hellojb ,
You can use below dax functionIF(DISTINCTCOUNT(Table[Column]) > 1,CONCATENATEX(VALUES(Table[Column]),(Table[Column]),"-"),SELECTEDVALUE(Table[Column]))what about if there are mutiple columns filtered?
U can use
CONCATENATE DAX function and combine the values from multiple columnsRegards
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.
