KPI

[Abdult]

Can a drop down of KPI be created in PBI? Think about a situation where a user wants to view a headcount, attrition rate & hires by location. Can the user switch between these measures using dropdown?

[AlB · Accepted solution]

Hi @Abdult

If I understand the request correctly, you can:

1. Create a ancillary 1-column table, KPITable, with the names of the KPIs.  Example:

KPI

Headcount

AttritionRate

Hires

2. Place KPITable[KPI] in a slicer. The user can selct here the desired KPI 

3. Create the measures that will calculate each of the KPIs

[ Headcount_Measure ]

[ AttritionRate_Measure ]

[ Hires_Measure ]

4. Create a generic measure that will calculate the desired KPI based on the user's selection. Something like:

GenMeasure =
VAR selected_ =
    SELECTEDVALUE ( KPITable[KPI] )
RETURN
    SWITCH (
        selected_,
        "Headcount", [ Headcount_Measure ],
        "AttritionRate", [ AttritionRate_Measure ],
        "Hires", [ Hires_Measure ]
    )

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.