Forum Discussion

arafmustavi's avatar
arafmustavi
Frequent Visitor
4 years ago
Solved

Data Visualization with Rule Based Color in Column Graph

Hi Everyone,   I have a summarised Dataset where the Fields are like this. Category -- Budget -- Consumed  A -- 1000 -- 500 B -- 4000 -- 4500 Now I want to Generate a Bar Graph with Budget vs C...
SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

arafmustavi I created this measure:

 

Color = 
SWITCH(
    TRUE(),
    SUM('Table'[Consumed]) > SUM('Table'[Budget]), "Red",
    "Green"
)

 


In the visual settings on the Bars colors I used the conditional formatting (Fx) option:


Then set it to this:

 





      

Showcase Report – Contoso By SpartaBI