Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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. |
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. |