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 want to be able to do the following
1. When no selection is made on a slicer: Return "All"
2. When 1-3 selections are made on the slicer: Return "text1,text2,text3"
3. When 4 or more selections are on the slicer: Return "text1,text2,text3, ....."
The DAX below works for 2 and 3 but not 1. When no selection is made on the slicer i get "text1,text2,text3, ....." instead.
Solved! Go to Solution.
It works IMO.
Scenario 2: 2 selection
Scenario 3: More than 3
Proud to be a Super User!
Hi @dasare8890 ,
Whether the advice given by @bolfri has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry
It works IMO.
Scenario 2: 2 selection
Scenario 3: More than 3
Proud to be a Super User!
Thank you Bolfri!
looks like I had "Filters on all pages" which was preventing this to work on my end.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |