Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ‘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

Need Help

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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!

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,

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

     

     

    I hope that solved the issue 🙂

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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?