Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

How to make a KPI and a Sub KPI with grouping dashboard

hi all,

 

am having a challenge to have a main KPI and Sub-KPIs as groups with + to open subgroups and - to close subgroups like excel.

 

attached pictures are an example on excel how i want to have it on Power BI

 

1.PNG2.PNG

 

I really need help thank you for your time

 

 

 

4 REPLIES 4
v-evelk
Microsoft Employee
Microsoft Employee

Hi,

 

I know only one visual that allows to combine several KPIs in one table and it is "Power KPI Matrix".

However, it is still developing and collapsing/uncollapsing feature is not implemented there yet.

 

Anyway, you can check Power BI visuals store to look for an appropriate visual.

If you don't find anything suitable, there will be only one case -- to develop own visual with necessary functionality.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Anonymous
Not applicable

Dear V-evelk,

 

I think i need to develop a custome visual, unfortunatly i dont know how.

 

can you please support me ?

 

Regards,

Abdulkareem

Hello Abdulkareem,

 

Sure,

You can strat from this link.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Anonymous
Not applicable

Keeping in mind that i need to have all the other measures actuals and planned in the same row for each KPI whether its main kpi or sub or sub sub

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors