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.
Hi,
The Title I want is: when I select every province, the title would show the same as nothing selected.
For example, when nothing is selected, the title looks like this: Weekly Report - All Provinces
If I select eveything, right now the title looks like this:
But I want it return the same as above: "Weekly Report - All Provinces"
-------------------------------------------------------------------------------
The mesuare I created:
Solved! Go to Solution.
Ahhh I see, here you go. I have edited my solution above to include this change. It works by looking at the number of commas in the list and comparing that to the total # of provinces to detect when ALL provinces are selected. I also attached a .pbix file with the solution.
Hi @kkwang
try using the method shown in this video, there might be few modifications are required: https://youtu.be/w6vtCEQ64Kk
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Reagrds
This solution has the drawback of using a hard-coded number of maximum selection values. In the example given, the maximum is 4 because there are 4 in the slicer.
If one were to add more options to the slicer, then they have to also change the measure.
Here is the DAX you are looking for. I have also attached a .pbix file with a working solution.
Mediocre Power BI Advice, but it's free
Thanks soooo much!!! It's working perfectly now!!!!
Happy to help!
Hi, thanks for your help!! but the measure still doesn't work unfortunately....
Ahhh I see, here you go. I have edited my solution above to include this change. It works by looking at the number of commas in the list and comparing that to the total # of provinces to detect when ALL provinces are selected. I also attached a .pbix file with the solution.
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |