Power BI Clustered Column Chart Conditional formatting and Analytic line in Power BI Service

[vboomer]

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?

[vboomer · Accepted solution]

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 

[v-jianpeng-msft]

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.

[v-jianpeng-msft]

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.

[lbendlin]

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 .