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...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Manav-Shah 

 

You can try the following.

 

Relationship:

 

1. Create a calculated column

 

 

Column = 
IF (
    Dashboard[Research Problem] = RELATED ( 'conditional formatting'[Problem] ),
    IF ( 'Dashboard'[Value] >= RELATED ( 'conditional formatting'[Total] ), 1, 0 ),
    0
)

 

 

2. Follow the settings shown in the screenshot below

 

 

Is this the result you expect?

 

Best Regards,
Community Support Team _Yuliax

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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