Forum Discussion
Graph range conditional formatting not working with a measure
Thanks, I seem to have resolved it. I rebuilt the graph and now it's working correctly when I filter on the area so not sure what was different the first time around. I didn't need to change the measure. Note I did do a quick check as you have above with a table the same as my graph dimensions and I get a different value for each year & month as you have in your table but when I use it in the axis it takes the value that shows when I put the measure in the card, i.e the value of the total line in the table
I'm not allowed to share the PBIX file it's against our companies confidentiality rules. I will try and spend some time next week mocking up some example data to share.
Hi GS76 ,
Is there any updates?
As Miguel said, it is context related. If you want to check if your conditional formatting returns correct result, you should keep it in the same context. Here, when you put it in the card, it's already missing a lot of relevance to your bar and line chart.
You could check it by duplicate the second bar and line chart and change it to the table visual. And then put your measures that you used as conditional formatting into the table visual.
Based on this, you can more clearly determine where there is a problem with the way the measure is written.
Here I made a sample for detailed explanation.
As you can see, the measure is "MAX('Table'[Sales])". It returns the max value.
In the card visual, it shows the max sales value of the Table. However, in the table visual, it shows the max sales value of each row due to the context. For example,the max value is 30 in 2023.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks, I seem to have resolved it. I rebuilt the graph and now it's working correctly when I filter on the area so not sure what was different the first time around. I didn't need to change the measure. Note I did do a quick check as you have above with a table the same as my graph dimensions and I get a different value for each year & month as you have in your table but when I use it in the axis it takes the value that shows when I put the measure in the card, i.e the value of the total line in the table
Sometimes it's the magical moments that happen. Anyway, glad your problem was solved, GS76 .
If possible, please mark your reply as solution. It is beneficial for future people to quickly check answer.
Best Regards,
Stephen Tao