Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to do conditional formatting having different rules for the same column

Hi,   I am trying  to attach conditional formatting for one of the columns in my report. Now I have different set of rules for different rows of the same column. Is there a way to add different set...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

Anonymous 

Yes, it should be possible.  Can you share some sample data and expected results?  Please share the sample data in a table format, not a screen shot.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Goals Current Performance Expected Performance Indicator 
    YTD Old Application15451325116.6
    YTD New Application798101298.7
    Avg Days from Application to eligibility 2030-10

     

    I want to add conditional formatting on Indicator column where the first two rows have a percentage calculated value and the bottom one is the difference between Second and third columns. 

    • jdbuchanan71's avatar
      jdbuchanan71
      Super User
      6 years ago

      In your example can you tell me what is a column in a table and what is a measure?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi,

         

        Since i am using a live connection with SSAS MD cube, I had created these as calculated columns and created a new DSV to import it in Power BI.

         Thanks Ayush