Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
79 | |
76 | |
62 | |
60 | |
48 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |