How to Fix Column Colors

[spartanboy]

Hello,

Here the slicer is structured in a way to only select 2 values at anytime. Irrespective to the dates or month selected, the color legend should be the same. How can I fix the first column to alaways be "Black" and the second column to be "Yellow"?

Thanks,

[v-yalanwu-msft · Accepted solution]

Hi, @spartanboy ;

You could create a condition measure . then set condition format.

condition = IF(MAX('Table'[Date])=CALCULATE(MIN('Table'[Date]),ALLSELECTED('Table')),"Black","Yellow")

Then set it.

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@spartanboy , if you are using legend you can not fix the color, it will choose from top colors.

For Just axis with one measure and no legend, You can create a color measure and use that in conditional formatting using the field value option

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...

If this does not help
Can you a sample pbix after removing sensitive data.

[spartanboy]

@amitchandak While in another example below, MONTH is a legend. What do you mean by top colors? do you mean default colors?