Conditional formatting on cards not working when I publish

[rilimonv]

Hi all,

I have several "card" visuals in my power Bi report, which sow sales and variances to budget and forecast. I added conditional formatting so that it would turn red if the number<0, and green if it is >0. 

How I formatted these cards is: Clicked on the card visual, then under visualizations, clicked on format, then on background, and besides the word "color" theres 3 dots. I clicked there and selected conditional formatting:

This works fine in Desktop, but when I published, for some reason all cards appear white, with no background (i.e conditional formatting not working). 

I looked in the report while online to see if the conditional formatting is still there, and it is. this is a screenshot taken while looking at the published report:

Does anyone have any idea as to why this might be happening?

Thanks!

[ShaoyuHung]

Unsolved so far.

Conditional formatting working on Power BI Desktop , but not working on Power BI Report Services , 

Does anyone have any idea as to why this might be happening?

Thanks!

[v-easonf-msft]

Hi ， @rilimonv 

Unsolved so far.

And you also can follow these issue post:

https://community.powerbi.com/t5/Issues/Card-backgrounds-with-conditionally-formatted-colours-not/id...

https://community.powerbi.com/t5/Service/Conditional-Formatting-on-Service-suddenly-disappeared/m-p/...

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-easonf-msft]

Hi , @rilimonv 

For the issue, I cannot reproduce it here.It works well in my powerbi service.

Can you use my pbix file to test it again  in your powerbi Service?

Pbix attached

What connection mode you are using and what type of your datasoure?

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rilimonv]

@v-easonf-msft  thanks for sharing. I continue to have the same issue - works fine in Power Bi desktop but once I publish, the card won't pull the conditional formatting.

I am connected to a server using analysis server, and then to a dataset which is a cube.

[rilimonv]

@v-easonf-msft 

I should add that in the same report, i have a matrix with conditional formatting and it works fine both in powerbi desktop as well as when i publish. the issue seems to be only with the cards.

[v-easonf-msft]

Hi , @rilimonv 

Can you tell me your tennant (Where is your date stored in)  and  your PowerBi Service version.

Please find them  in powerbi service "help and support"  -> "About PowerBI"

Best Regards,
Community Support Team _ Eason

[rilimonv]

@v-easonf-msft 

Hi. 

Service version13.0.12816.122

Your data is stored inWest Central US (MSIT)

Is this what you need? Let me know if you need something else

[v-easonf-msft · Accepted solution]

Hi , @rilimonv 

I tested it again in msit today, and the problem seems to be fixed.

Is it resolved on your side?

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rilimonv]

@v-easonf-msft Hi! Yes! it has been resolved. thanks for your support!

[v-yetao1-msft]

Hi @rilimonv 

I want to know what is your solution? Because I also encountered a similar problem. Can you share it? Thanks a lot.

Best Regards

Community Support Team _ Ailsa Tao

[v-easonf-msft]

Hi , @rilimonv 

I understand and can reproduce your problem.

If we have any conclusions on this topic ,I will post back .

Best Regards,
Community Support Team _ Eason

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".