Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Conditional Formatting based on other measure value

Hi Team,

I have below data where I wanted to Highlight YGoalPer as green if the YGoalPer < YestForm else mark the background as green

 

 

When I check Conditional Formatting option , I dont see the comparison option there.

 

Kindly guide.

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi,

     

    You can do this using the new Power BI feature, released yesterday: Conditional formatting by a different field.

     

    Update Power BI Desktop to the latest version: 2.58.5103.501 64-bit (may 2018)

    Create a new column YGoalPer_IsLessThan_YestForm = IF('Table'[YGoalPer] < 'Table'[YestForm];1;0) 

    And now you can do this:


     

    Regards.

     

     

  • Anonymous's avatar
    Anonymous
    8 years ago

    Ohh thanks for useful info, it worked like charm

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi,

     

    You can do this using the new Power BI feature, released yesterday: Conditional formatting by a different field.

     

    Update Power BI Desktop to the latest version: 2.58.5103.501 64-bit (may 2018)

    Create a new column YGoalPer_IsLessThan_YestForm = IF('Table'[YGoalPer] < 'Table'[YestForm];1;0) 

    And now you can do this:


     

    Regards.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Ohh thanks for useful info, it worked like charm

      • michaelshparber's avatar
        michaelshparber
        Advocate V
        7 years ago

        Anonymous 

        Can you do this with Data Bars?

        I would like to set a maximum number as a measure...

        Thanks