Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
@hellojb See if this helps: The Most Amazing, Mind Blowing Dynamic Slicer Titl... - Microsoft Power BI Community
Hello @hellojb ,
You can use below dax function
what about if there are mutiple columns filtered?
U can use
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |