- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

card measure that changes text if there are multiple filters applied in different slicers
I need help in creating a dax measure that changes the text on a card when more than one slicer is filtered.
i have 3 slicers:
slicer A
slicer B
slicer C
I want the text to change from Selected Category X to "selected Values" when more than one slicer is filtered.
the dax I have below only works for one or more values selected in the same slicer.
if(isfiltered('Table1'[A]), (if(DISTINCTCOUNT('Table1'[A])=1, SELECTEDVALUE('Table1'[A]), "Selected Category A"), if(isfiltered('Table1'[B]), (if(DISTINCTCOUNT('Table1'[B])=1, SELECTEDVALUE('Table1'[B]), "Selected Category B"),
if(isfiltered('Table1'[B]), (if(DISTINCTCOUNT('Table1'[B])=1, SELECTEDVALUE('Table1'[C]), "Selected Category C")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@hellojb The Most Amazing, Mind Blowing Dynamic Slicer Titl... - Microsoft Power BI Community
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
06-27-2024 09:31 AM | |||
01-10-2023 04:22 PM | |||
01-29-2024 09:33 AM | |||
06-18-2024 06:13 AM | |||
08-01-2024 07:43 AM |
User | Count |
---|---|
85 | |
78 | |
41 | |
40 | |
35 |