Conditional formatting doens't work after publishing

[Anonymous]

Hi everyone,
I have a problem with Conditional formatting in PowerBI service.  I am usingSSAS with live connection.  We are moving from PowerBI desktop to PowerBI service and the conditional format does not work on PowerBI service.
This is what have I done but nothing helps.

- upgrade PowerBI to the lastest version
- Remove the column with  condition format and published report. Then add that column with condition format and published again.
This is how I set up the conditional format

Color shows collectly on desktop version 

But not on PowerBI service.  On PowerBI service it shows only data without color. 

Note : I try to change from background color to condition format and it
work.

Any suggestion ?  🙂 

[v-lid-msft]

Hi @Anonymous ,

Based on my test ( we connect a dataset with Live Connection), the condition format works fine on my side. Have you tried download the pbix from the incorrect report in power bi service and then open it in power bi desktop? We did not understand "change from background color to condition format and it work. ", the screenshot you have shared seems has a condition format of backgroud.

Best regards,

[Anonymous]

@v-lid-msft  I did download pbix from PowerBI service and open it in powerBI desktop. The Conditional formatiing it working fine in PowerBI desktop. I rename the file and publish it to powerBI service and it doenst work. This is weird.

Regarding to "change from background color to use icon  in condition format and it work. "
I can use Icon in conditional format and it appears in PowerBI service. 

[venal]

@Anonymous 

May i know the visual you are using?

If it is table visual, i heard that there was an issue last week with the conditional formatting.

If it is the same issue, please raise a support ticket with all relevant details and community link for reference.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

[Anonymous]

@venal   I use just normal table.

[Anonymous]

Hi @Anonymous ,

It should work, could you please share the screen shot from PBI services.
Check weather the column remains conditional formatting.

Best Regards,
@Mail2inba4

[Anonymous]

@Anonymous  Thank you for your answer. The conditional formatting is there on powerBI service but the color doesnt appear. 

It shows correctly on desktop version.