Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to create a filled map where the colouring is done from green (lowest value) to red (highest value). The values are not static as they dependend on other filters that are applied first. (e.g for one filter value 1 might be the minimum where for a second it could be 1000)
I think previously this was possible using 'conditional formatting' according to this Choroplets MS documentation, but I don't seem to get these options on my Desktop version. I would consider it a quite important missing feature if this was not possible.
Solved! Go to Solution.
Hi @spijs ,
if you remove a field from Legend section (Fields pane), you will be able to apply dynamic color formatting in Conditional Formatting section:
Hi @spijs ,
conditional formatting location changed after recent Desktop update. You may locate it under 3 dots under Data Colors section now:
I don't seem to find these dots or find that 'default color' field. See screenshot:
Looks like you've added some field (w/ 0,1 values) into Legend field. If you remove that field from Legend section, you should see the dots.
Best,
Matej
Well actually there are more possiblities than just 0 and 1. I only took a screenshot of a subset of the options as I have in this specific case 14 possible values, but I could have for example 5 with another filter applied. I don't see any blanks or anything like it however, so I'm not sure what you are suggesting exactly.
What I want to have is Power BI to treat the field as a numeric value rather than as a fixed list.
Please let me know if I misinterpreted your solution.
Hi @spijs ,
if you remove a field from Legend section (Fields pane), you will be able to apply dynamic color formatting in Conditional Formatting section:
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |