Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
93 | |
85 | |
76 | |
67 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |