Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi,
Please check the attached file.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the attached file.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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!
Hi,
I wrote a bit more detail about explaining how the measure works in the link down below.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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
Yes, I did join the two tables on Country. And it will work dynamically.
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?
Hi,
I made a measure to use for conditional formatting called "test" :
I hope that solved the issue 🙂
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |