Forum Discussion
Column Chart with colored target range
Hi, I was wondering if it's possible in Power BI to show a colored target range (like a green bar from 80-90%) within a column chart? Any help will be appreciated! Thanks in advance.
You can create a color measure and use that in conditional formatting(Advance Control), Choose a field and this measure
example
Color Category = SWITCH(true(),
Max(Sheet1[Category]) in {"A"} && Sheet1[Target]<10,"green",
Max(Sheet1[Category]) in {"B"} && Sheet1[Target]<10,"orange"
"red"
)
Refer : https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values