Forum Discussion

Manav-Shah's avatar
Manav-Shah
Icon for Helper I rankHelper I
2 years ago

Conditional Formatting in Power BI using measures.

I need to implement the same conditional formatting in Power BI using a measure that apper in below excel sheet. I have two data sheets in Excel. 1) Dashboard     2) Data for conditi...
Manav-Shah's avatar
Manav-Shah
Icon for Helper I rankHelper I
2 years ago

Hi Anonymous ,

 

Can you explain how you calculated 'Dashboard[Value]' in power bi?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Manav-Shah 

 

’Dashboard[Value]‘ field are the raw data from the sample created based on the table you provided. 

 

Sample:

 

 

If I've misunderstood you, please provide detailed sample data and the results you are hoping for: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

 

Best Regards,
Community Support Team _Yuliax

  • Manav-Shah's avatar
    Manav-Shah
    Icon for Helper I rankHelper I
    2 years ago

    Hi Anonymous ,

    Sorry, I forgot to mention my main data format.

    I have data in below format and I have created formulate table and then apply conditional formatting, so I have to do same thing in Power BI

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Manav-Shah 

       

      I would like to apologize for the belated reply.

       

      If your problem is not solved yet, can you tell me how month value is obtained?

       

      Best Regards,
      Yulia Xu

      • Manav-Shah's avatar
        Manav-Shah
        Icon for Helper I rankHelper I
        2 years ago

        I have data in below format 

         

        then I used countifs funcrtion for calculating all months total.

         

        For conditional formatting, I intend to set conditions based on the average of the last three months multiplied by 140%. For instance, when applying conditional formatting for January, it is computed by taking the average of October, November, and December and multiplying it by 140%. Similarly, for February, it is calculated using the averages of November, December, and January, then multiplied by 140% and so on for other months.