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! Request now

Reply
Shloka_Lakhani
Frequent Visitor

want to create Matrix table using month name and grand total

Hello,

I want to create matrix table into powerbi dashboard. Some thing like like as i have mention in screenshot

Shloka_Lakhani_0-1718706462825.png

I have created 90 % same like this but concer is:

Shloka_Lakhani_1-1718706512109.png

1) I want Total with Two partition HIP & No HIP as 1st Screenshot.
2) I want  TBV, B_hip_invcentive etc header as center align.

Thank you in advance. Your response is very valuable.

1 REPLY 1
VijayP
Super User
Super User

@Shloka_Lakhani 
By default the categories will not be shown where there are no values , so  you must activate them

use this pic reference to show all where there is no data 

VijayP_0-1718712882335.png

 

To aling the column headers , use the option shown in the picture

VijayP_1-1718712929704.png

 

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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