Forum Discussion
massaker
9 years agoFrequent Visitor
Conditional Formatting Color Buckets on Maps
Hey Guys, I'm trying to recreate a map I made in tableau last year in Power BI. I used conditional formatting to set a range of values equal to a color (if x >1million, then "red"). I put the ra...
massaker
9 years agoFrequent Visitor
Thank you Eno. Yes, the colors correspond to $ brackets. 1-100k is gray, 100k-250k is the light peach, and so on to Red which is 1m+.
Now I'm wondering how to define those in the legend? Do I need to create a new column or measure to define the buckets? I tried creating an if statement (if <100k, True, else False). But that didn't seem to work. Any recommendations?