conditional formating on colors

[Avivek]

Hello everyone,

I have a bar chart which shows sales only by systems which are under division called spine and bba. In that bar chart i want sytems for bba to be of same color and division spine to be of another color.

I tried using conditional formating as sum of division id and trying to apply by rules or gradient format style but it did not work. I also tried creating a dax:

Colour_Dax = IF(sum(SALES[DIVISION_ID])=4000643,"#B887AD")

and used this on a conditional formating rules and gradient but even that did not work. Can someone please help me on this?

[v-rzhou-msft · Accepted solution]

Hi @Avivek ,

According to your statement, I think you can try Fromat style "Field value" to use this measure for colors.

It works on myside.

For reference: Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.