change the color of the bars of a chart if ...

[chucky69]

Hello,

I want to change the color of some bars of my bar chart if a target carried by another measure is not reached.

I am using SSAS direct link mode connection and cannot write script in PBI RS Desktop to achieve my result.

Customizing the color on this visual by adding rules does not allow you to compare 2 measurements.

Thank you for your help.

[Icey]

Hi @chucky69,

Since you can't create measures when using Live Connection, it is suggested to create a measure to "compare 2 measurements" at the data source - SSAS.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.