Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Conditional formatting based on another column

I would like to apply conditional formatting to matrix values based on a column that is not used in the matrix. This link shows how to do it: https://docs.microsoft.com/en-us/business-applications-re...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Yuliana Gu, 

 

I'm using the PowerBi version 2.68.5432.761 64-bit (April 2019) and am still getting the same issue of the screenshot from the orginal question, of not being able to base the formatting on another column. 

 

I've tried your solution and it doesn't work with what I am aiming to do. 

 

My aim is to compare previous month data to the recent month data, and highlight the recent month data in red or green depending on if it is higher or lower than the previous month. 

 

Please can you advice?

 

Kind Regards,

 

Jess 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous  were you able to achieve this? 

"to compare previous month data to the recent month data, and highlight the recent month data in red or green depending on if it is higher or lower than the previous month"

 

I am looking to do the same but dont have solution yet. 

 

Thanks