Need help with Conditional Formatting based on dynamic threshold values

[guptav13]

PBI SAMPLE FILE ATTACHED 

I have visual 1 and visual 2.  When I select a country in Visual 1, Visual 2 shows data for that country.

I want  a conditional formatting in Visual 2 to highlight ‘Subjects’ Or ‘Average of Marks’ where ‘Average Of Marks’ is below PassingGrade for that Country.

For example If I select Japan in Visual 1, Math and Physics in Visual 2 should get highlighted on the basis of ‘Threshold for Reference’ table

But If I select Singapore in visual 1 , Physics should get highlighted on the basis of ‘Threshold for Reference’ table

[Jihwan_Kim · Accepted solution]

Hi,

Please check the attached file.

Thank you.

[guptav13]

Big thanks, this works!!

Is there a way to highlight them with Red flags like below instead of background color?

If you could share the file or code snippet to do that would be great!

[Jihwan_Kim]

Hi,

I wrote a bit more detail about explaining how the measure works in the link down below.

https://jihwankimcscp.wixsite.com/supplychainflow/post/conditional-formatting-in-matrix-table-visual...

[Jihwan_Kim]

Hi,

Thank you for your feedback.

I amended the measure, and now it show a flag based on the condition.

Please check the attached file if it suits your requirement.

Thank you.

[guptav13]

Hi, Can you share the power Bi file?

Did you join the Passing Score and Sheet 2 tables? Will this work dynamicaly if I selecting different countries in Visual 1

[PowerUserR]

Yes, I did join the two tables on Country. And it will work dynamically.

[guptav13]

Hi , I tried replicating your approach as it is simplete but it is not working correcly, Check below for instance. THis should have highlighted Math as well? I think Test measure need to be tweaked a little bit. You are using Sum, and not average there, why?

[PowerUserR]

Hi,

I made a measure to use for conditional formatting called "test" :

I hope that solved the issue 🙂