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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Creating Categories and Subcategories in Power BI

Hi All,

 

I'm new to Power BI and I've been trying to replicate some stuff from excel to power bi. I am having trouble putting a category label on the matrix and then the subcategories.

 

This is what I'm trying to achieve:

Screenshot 2023-04-27 172626.png

 

and this is my sample raw data:

Screenshot 2023-04-27 172712.png

 

Help would be appreciated!

Thank you

5 REPLIES 5
ribisht17
Super User
Super User

Hi @Anonymous 

Matrix

ribisht17_0-1682592114560.png

 

 

 

Table

ribisht17_1-1682592193298.png

 

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

 

 

Anonymous
Not applicable

Hi @ribisht17 ,

 

Thanks for the reply!

 

Only lead category is showing in the matrix but not for lead status. Is there any way to show both of them?

 

You can bring another Matrix like this

 

ribisht17_0-1682752322103.png

 

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

 

Idrissshatila
Super User
Super User

Hello @Anonymous ,

 

you just out them above each others.

 

Idrissshatila_0-1682588441573.png

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Anonymous
Not applicable

Hi @Idrissshatila ,

 

Thanks for the reply!

 

But that doesn't seem to work for me. It is only showing one of the categories if I were to put them as you mentioned.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

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