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
purana2002
Helper I
Helper I

Power BI Matrix report

I have data in this format ,

 

YearMonthCallsDriverScoreSurveyCountSurvey_ScoreSurvey_Score IncCovertionRate9L Conv_Rate Inc9L Conv_Call CountConv Call_Count IncBattery_GoalBattery_Sale CountBattery_Sale Inc
2017695.27272727000.88838162400.041935484000441.584182700
2017697.58333333000.955791562171.50.041935484000441.584182700
20176122000.92129629600.041935484000441.584182700
2017698000.93452248171.50.041935484000441.584182700
20176106.7777778000.946204968294.250.085990338000212.431027500
20176114.6666667000.977207482316.250.085990338000212.431027500

 

I want to build something like this, But I want avg of all month insted of Grandt Total on the end of Matrix.  and the Blank space between few measures and Matrix to be fixed columns 1-12(month) instead of growing dynamcally. How can I achieve this?

 

CategoryMonths
 123456789101112AVG
Calls103109          106
Survey Count194          11.5
Driver Score97.6%93.2%          95.4%
Survey Score289288          288.5
Survey  Incentive$131.84$136.25          $134.05
               
Driver Score97.6%97.7%          97.7%
Batteries Sold1819          18.5
Member Testing Rate83.0%91.0%          87.0%
Conversion Rate62.0%72.0%          67.0%
Battery Sales Incentive$90.00$190.00          $140.00
               
Count of OTG Calls (Mobile Techs Only)             
OTG Incentive$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
               
Incentives Paid$221.84$326.25$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$274.05

 

1 REPLY 1
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @purana2002,

I want to build something like this, But I want avg of all month insted of Grandt Total on the end of Matrix.  and the Blank space between few measures.

I don't think there is a direct way to do it in Power BI currently. You can add it as an idea on Power BI Ideas forum to improve Power BI on this feature. Here is similar idea for your reference. Smiley Happy

 

Regards

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