Conditional Formatting based on other measure value

[srlabhe123]

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.

[Anonymous · Accepted solution]

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 · Accepted solution]

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.

 

[srlabhe123 · Accepted solution]

Ohh thanks for useful info, it worked like charm

[michaelshparber]

@srlabhe123 

Can you do this with Data Bars?

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

Thanks