color bar chart

[Anonymous]

Need help in color code bar chart according to values each bar shows. I am not able to see any roller paint option, neither fx option to change bar color according to measure. 

Kindly assist.

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

Pls refer the below:

base data:

create visual:

Bar color = 
SWITCH(
    TRUE(),
    MAX('Table'[value]) = 10, "#FF0000",
    MAX('Table'[value]) = 20, "##00FF00",
    "#000000"
)

Configuration:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[amitchandak]

@Anonymous , if you have used Legend, you will not see fx option, otherwise you should able to see that

In bar visual how use two-axis, in place of legend

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://www.youtube.com/watch?v=RqBb5eBf_I4

[Anonymous]

Thanks Amit,

I have removed legend, still no option for roller paint or fx.