Forum Discussion
Conditional Formatting between two bars in bar chart
Hi OneHotEncoder,
You cannot use condittional formating for a bar chart with two measures or a legend on it since each one will get it's singular color.
Have you tried using the error bars?
In this example I have create a combo of line and bar chart.
Using the error bars was abble to create this look and feel:
Se PBIX file attach.,
This is only one workaround there are some custom visuals that allows this.
Other option can be to create a staked column chart that has each level of the values until your target or above your target.
Hi OneHotEncoder,
You cannot use condittional formating for a bar chart with two measures or a legend on it since each one will get it's singular color.
Have you tried using the error bars?
In this example I have create a combo of line and bar chart.
Using the error bars was abble to create this look and feel:
Se PBIX file attach.,
This is only one workaround there are some custom visuals that allows this.
Other option can be to create a staked column chart that has each level of the values until your target or above your target.