Forum Discussion

spijs's avatar
spijs
Frequent Visitor
6 years ago
Solved

Dynamic colors for filled maps

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 f...
Need Help
  • MatejZukovic's avatar
    MatejZukovic
    6 years ago

    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:

     

spijs's avatar
spijs
Frequent Visitor
6 years ago

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.

MatejZukovic's avatar
MatejZukovic
Resolver I
6 years ago

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: