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.
As you can see from the snippets when I chose the "Don't format" option in the How should we format empty values? drop down, it returned the states with null values having the filled color of the maximum value(green). I also tried the "As zero" option and that made those states with null values to therefore take the filled color of the minimum (light red). The remaining option is to set the null values as a specific color which I ended up doing as a workaround, setting it to white which does not exactly map with other parts of the world that are not part of the data but show in the map. However I want to know, shouldn't the "Don't format" option show the null-value states in the map as non-formatted?
Any assistance on this will be appreciated.
Thanks, @amitchandak for your effort and response! However, isn't the point of the option in the conditional formatting, is to ensure that states in my total revenue by states table that have a blank value for total revenue have the option to appear with no formatting?
You also mentioned that my measure should make it 0 or empty in string format. I don't think I understand that.
The other workaround I have done was to add a Filter on the visual for Total Revenue is greater than 0.
I am trying to understand the purpose of the "How should we format empty values?" and what does it apply to.
@FUNMCT , I tried with both zero and do not format, And it did not color for me.
Make sure, their state does not appear in the table if it has a blank value. Your measure should make it 0 or empty in string format
User | Count |
---|---|
85 | |
84 | |
68 | |
66 | |
55 |
User | Count |
---|---|
126 | |
102 | |
90 | |
84 | |
66 |