Forum Discussion

trevor's avatar
trevor
Helper I
7 years ago
Solved

How to apply Minimum Thresholds to visualizations?

This should be simple but I can't get a threshold parameter to work using what if. I saw a worked example and did exactly that but it fell over at the last step. I have a table of sales opportunitie...
  • Anonymous's avatar
    Anonymous
    7 years ago

    trevor,

    Is  Probability a existing column in your table? If so, please create the what if parameter as shown in the following screenshot, then create a measure rather than a column in your original table.


    Measure 2 = IF(MAX(Table[probability])<Parameter[Parameter Value],0,1)




    Regards,
    Lydia