Forum Discussion

Avivek's avatar
Avivek
Post Partisan
3 years ago
Solved

conditional formating on colors

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?
 

1 Reply