Bar chart - conditional Y Axis Label color based on value/measure

Question

I have simple table called Data, what I need is to have Y Axis on bar chart colored: red if measure called Result is 0, Green if measure Result is 1.
Result = SUM(Data[Budget]) - SUM(Data[Cost]).
It works fine in table viz, but in Bar Chart all Y Axis Labels have the same color based on Result TOTAL value (Total Row from Table). Could you please tell me how to fix this ?

v-zhangti · Answer

Hi,&nbsp;Anonymous&nbsp;
&nbsp;
The Y-axis calculation only returns the final value of Total equal to 1 and the color Red, which cannot be displayed separately.&nbsp;

&nbsp;
Unfortunately, this is by design. Power BI is now unable to achieve what you need . You can submit an idea for it at&nbsp;https://ideas.powerbi.com/forums&nbsp;and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
&nbsp;
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

pijushroy · Answer

Hi&nbsp;Anonymous&nbsp;Please try this&nbsp;If solve your requirement, please&nbsp;mark this answer as SOLUTIONIf this comment helps you, please&nbsp;LIKE this comment/Kudos

anonymous · Answer

hi&nbsp;PijushRoy&nbsp;I already tried that, that's why every label is green in my bar chart and this is wrong - only Product A should be Green, B and C red (same as in table)&nbsp;

pijushroy · Answer

Hi&nbsp;Anonymous&nbsp;Please share data or pbix file (non confidential)

anonymous · Answer

hi&nbsp;PijushRoy&nbsp;,unfortunately I cannot share PBIX.It is very simple file with one table with data and measure Reasult.in table viz conditional formatting works good, every row in Product is treated differently and color is set there individually. The problem is with Bar chart, it is setting colors for all Y axis labes based on a Result total value for whole table (if we will change cost for Product A to be higher as budget, then Result value for whole table will be 0 and all labels in Bar chart Y axis will be red - I already tested that). Maybe it is a bug? It looks like ther is no filter context for Result measure in Bar chart.... Screenshots below&nbsp;&nbsp;&nbsp;