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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors