Forum Discussion

HS_PDS's avatar
HS_PDS
Frequent Visitor
6 years ago
Solved

Conditional formatting based off parameter input

Are we able to conditional format a value based off a what-if parameter input. For example I have the following column "Percentage" along with a what-if parameter called "threshold". I want to highlight any row that is less that whats in "threshold". 

 

Example table:

 

Is this even possible? I tried to use the format by field value without any luck. Any direction is appreciated.

 

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    HS_PDS create  a measure for color to check the threshold and then use that measure to highlight for conditional formatting.

     

    Below Threshold color = 
IF ( [Your Measure] <= [Threshold Value], "Red" )

     

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    HS_PDS create  a measure for color to check the threshold and then use that measure to highlight for conditional formatting.

     

    Below Threshold color = 
IF ( [Your Measure] <= [Threshold Value], "Red" )

     

    • HS_PDS's avatar
      HS_PDS
      Frequent Visitor
      6 years ago

      Thanks for that wonderful tip!parry2k 

       

      I initially knew that field base values use text, and should have thought of the helper column.

       

      Thanks again! Now I need to create a column to count each of teh highlighted values! 😄 

  • delidolu's avatar
    delidolu
    Regular Visitor
    3 years ago
    God bless you @parry2k, I've been dealing with this for a week, thanks to you, I solved it in 1 second.🙏