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 Community!
When I create a measure using the SWITCH() function that calls other measures depending of the selection in one slicer, the result shows as “Blank” values the “0” figure, Do you know how can I fix that?
Here’s a detail explanation:
If I use them directly in a Matrix, when the result is “0”, it shows “0” (that’s what I want):
But, when I use the next measure that “calls them” depending of the option selected in the Slicer, instead of “0” it shows BLANK(), do you know how can be solved that???
Solved! Go to Solution.
Field parameters offer a better way to achieve this. Instead of using a SWITCH measure, simply add each measure to a field parameter. These measures will be available in a slicer, and the formatting of each measure will be used in visuals.
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Proud to be a Super User!
Field parameters offer a better way to achieve this. Instead of using a SWITCH measure, simply add each measure to a field parameter. These measures will be available in a slicer, and the formatting of each measure will be used in visuals.
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Proud to be a Super User!
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |