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.
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.