Forum Discussion

ejhh12's avatar
ejhh12
Regular Visitor
6 years ago
Solved

Using parameters to set pass/fail mark

Hello,

I have the following example data:

NameCat1Cat2Cat3Avg
Ewan4423.33
James2332.67
Nick3011.33
Tim1502.33
William5555
Jack0122.33

 

I am new to Power BI so am struggling to build exactly what I would have built in Tableau. I want to be able to specify a "Threshold score", eg a value between 0 and 5 (intervals of 1). I would then like to create a 100% Stacked Bar or Pie Chart which shows the number of names which are above/equal to the threshold value vs the names that are below the threshold value for each category. The user could then be able to use the parameter slider and alter the value and as they do this, the graphs would update.

 

In my head, it should be simply:

IF (Cat1 >= Parameter, "Pass", "Fail")

 

Then set that as the legend on a Pie/Bar chart so (if the threshold value was 2 for example) we could produce the following:

 
 
 
 

 

 

3 Replies