Forum Discussion
Power BI Clustered Column Chart Conditional formatting and Analytic line in Power BI Service
In Power BI Desktop, I can add conditional formatting to dynamically color the columns for a Clustered column Chart - depending on the Value of the column. I can also add in an Analytic average line
This works fine in Power BI Desktop. It no longer is allowed on the service....The graphic does not render. I either have to remove conditional formatting or the Analytic Average line. It no longer allows both....
Does anyone know what changed here?
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
4 Replies
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
Hi vboomer
Thanks for your reply. You can mark helpful replies as solutions and your replies as solutions, so that other members of the community can quickly find relevant solutions when they encounter the same problem, reducing their search time.
Your sharing and cooperation will be the same as our previous community development. Thank you again for your cooperation!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.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .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.
