Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional Formatting working in desktop but not working in Power BI Service

Hi,

 

I have a simple review where a backgroud conditional formatting is applied to card visual. This works in Desktop & am able to see the color changes based on values but not working in Power BI service.

 

Please give me a notification, If incase anyone know why that so.

10 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous 

     

    Try different browsers, are you using chrome?

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Have tried opening the report in different browser but same result. No conditional Formatting

  • Is it published correctly? Check that. Clear cache and Try.

    • Anonymous's avatar
      Anonymous
      Not applicable

      tried that as well :(. Nothing works.

    • Anonymous's avatar
      Anonymous
      Not applicable

      I may need to try a restart once. if that works. vut its completly strange a solution works in Power BI desktop while not working in service at the same time.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous,

    Any specific options or security settings enabled on your report/database? It will help if you share a pbix with some dummy data for test.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi, Thanks for reply.

       

      This seems weird to me since i have been working on Power BI for past more than 3 years & saw something like this for the very first time. 
      Source i have used is excel & normal background formatting based on measure value 

      % GUD Match SAP Vs eCRM = DIVIDE([GUD_SAP Vs eCRM],DISTINCTCOUNT(SAP[GUD]))*100
       
      I apply formatting to be in divergent mode which is supposedly working fine in Desktop but not reflecting in Service.
      • Anonymous's avatar
        Anonymous
        Not applicable

         For e.g. I have this card visual only in my report & formatting is done on the basis of DAX measure which i have pasted in my earlier comments.