Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Automatic Color Assignment in Visual to New Entries

Good day everyone,

 

In our dataset that is updated every week, we have four different color choices i.e Green, Red, Yellow, and Ambiguous. For a column that has all 4 of these, it is easy to manually assign them. But, there are columns where only Greens exist or only Ambigious exist, and whenever a new color is added, it takes the default Blue color irrespective of whether it is Red or Yellow or any other color.

 

So, is there a way to program the visual in a way as to let Power BI know that hey if you get a Red value in this column, assign Red color to it, and Yellow for Yellows and vice versa?

 

If there's a way for this, then it'd be great. Thanks

1 Reply