Dynamic Slicer to update Thresholds

[Anonymous]

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

[MarkLaf · Accepted solution]

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)