Forum Discussion
Need help with Conditional Formatting based on dynamic threshold values
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 ‘Subjec...
Hi,
Please check the attached file.
Thank you.
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?