Forum Discussion
Solved
Conditional Formatting on Bar chart
I want to colour code my bar chart based on %value on my measure like if % <50 then Red when % between 50-90 then yellow and above 90 green. Used conditional formating option on Data colour Card. wor...
Thanks for reaching out,
yes this been resolved, I used number instead of % for my conditioning formating and it worked, but I wonder why I was not able to do this with % ,when my measure was like numerator/Denominator and formated this as %.
Did not get it can you elaborate.
In between refer
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
You can create a color measure like this and use after using fields in advance control
Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values