Matrix Conditional Formatting

[Anonymous]

Hi

I have a requirement where a matrix contains two measures say Measure 1 & Measure 2. I would like to apply conditional formatting on Measure 1 based on a condition applied on Measure 2. For this I shall be able to access Measure 2 from conditional formatting options available for Measure 1. But, this is not the case now. It would be very helpful if anyone can provide a workaround to achieve this requirement. Thanks!

[v-yuta-msft]

Hi Samrat,

What's the relationship between measure1 and measure2. Are they based on the same columns or different column? In addtion, could you please provide more details about what kind of conditional formatting are you going to achieve?

Regards,

Jimmy Tao

[Anonymous]

Hi Jimmy,

Thanks for the message. Please find below the explanation.

Measure 1 and Measure 2 are from the same fact table and the relationship between them is that, whenever the average of Measure 1 calculated for last 3 months is greater then current month value then Measure 2 would be 1 otherwise 0. The requirement here is to highlight the Measure 1 whenever the value of Measure 2 is 1. Additionally we don't want Measure 2 in the report only Measure 1 has to be included in the report and it has to be conditionally formatted based on the Measure 2 value. The basic requirement is to conditionally format a column based on other column value irrespective of whether the 2 columns are included in the report or not, at least we shall be able to properly hide the unnecessary column from being rendered in the report. I hope this makes the requirement clear. Please let me know in case of any clarifications. Thanks much for the help!

Regards,

Sam

[Greg_Deckler]

Have a look at this excellent article by @MindyJ: https://community.powerbi.com/t5/Community-Blog/Power-BI-Desktop-Custom-Aggregations-Formatting-and-...

[Anonymous]

Hi Greg,

Thank you for sharing the interesting article, I really appreciate it! This can definitely be considered as a work-around, however, the requirement is to conditionally format a column background based on other column value which should not be included in the report or hidden in the report. I also see that Power BI don't have an optimal way to hide columns in a report. I believe that they will come up with something soon. Thanks!

Regards,

Sam