Forum Discussion
Conditional formating in Multiple measure Bar / Column chart
Hi, Helping friends,
I need help creating a bar/column chart for multiple measures in the same visual. Like I have an axis for LY, Target, and CY data in the same chart with 3 measures.
I want to apply conditional formating only on CY measures compared with Target.
Please give me a proper solution.
1 Reply
A6bdulRehman , You can create a color measure and use that in conditional formatting with field value option
color =
var _change =[Net Sales YTD]-[Target Measure]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
