Forum Discussion
Power BI Clustered Column Chart Conditional formatting and Analytic line in Power BI Service
Interesting
I was using the gradient using a measure as the formula and then choose the lower color to the higher value color
i ended up using a duplicate measure doing the same calculation for the conditional formatting
that worked and could be published
you used to not have to do that
something changed in the service
but at least I got it to work
thank you for responding
Thank you lbendlin
Hi, vboomer
As you described, I use the following sample data:
In my testing, you need to add an average before using conditional formatting for your columns:
Then publish it to Power BI Service:
If you're conditionally formatting columns first and then adding averages, you may encounter this error:
I've uploaded the PBIX file of this test below.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.