Forum Discussion
Dynamic Slicer to update Thresholds
Hello
I have a table grouped at Purchase Order Level where I have a set of 10 Kpis.
- Selling Price - Cost / Selling Price
- Purchase Order Cost / Forecasted Margin
- and so on..
Based on the threshold that I have for each Kpi, I have a final measure that I Call "Status" that returns Ok if approved and Not OK if not approved.
Example:
IF(KPI_1 > 0.1 AND KPI_2 > 0.5,"Ok","Not Ok"
My question is:
- Is it possible to add a slicer/anything that the PBI user can change on its own, to update the threshold stabilished in the Status Measure for each KPI ?
Thanks
Diego
I believe you can achieve what you want with parameters.
1) Define whichever threshold parameters you want through Modeling > New parameter > Numeric range.
2) Update your measures to reference the threshold parameters instead of the hard-entered values.
Status = IF( [KPI_1] > [KPI_1_Threshold Value] && [KPI_2] > [KPI_2_Threshold Value], "Ok", "Not Ok" )Note that as indicated above, KPI_1 and KPI_2 must be measures, not calculated columns. E.g. if you are trying to compare non-summarized columns, you could just do KPI_1 = SUM( 'Your Table'[Value Column] )
(or perhaps use AVERAGE instead of SUM if you want the tresholds to make sense in (sub)total columns/rows)
1 Reply
I believe you can achieve what you want with parameters.
1) Define whichever threshold parameters you want through Modeling > New parameter > Numeric range.
2) Update your measures to reference the threshold parameters instead of the hard-entered values.
Status = IF( [KPI_1] > [KPI_1_Threshold Value] && [KPI_2] > [KPI_2_Threshold Value], "Ok", "Not Ok" )Note that as indicated above, KPI_1 and KPI_2 must be measures, not calculated columns. E.g. if you are trying to compare non-summarized columns, you could just do KPI_1 = SUM( 'Your Table'[Value Column] )
(or perhaps use AVERAGE instead of SUM if you want the tresholds to make sense in (sub)total columns/rows)