Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I have data in this format ,
| Year | Month | Calls | DriverScore | SurveyCount | Survey_Score | Survey_Score Inc | CovertionRate | 9L Conv_Rate Inc | 9L Conv_Call Count | Conv Call_Count Inc | Battery_Goal | Battery_Sale Count | Battery_Sale Inc |
| 2017 | 6 | 95.27272727 | 0 | 0 | 0.888381624 | 0 | 0.041935484 | 0 | 0 | 0 | 441.5841827 | 0 | 0 |
| 2017 | 6 | 97.58333333 | 0 | 0 | 0.955791562 | 171.5 | 0.041935484 | 0 | 0 | 0 | 441.5841827 | 0 | 0 |
| 2017 | 6 | 122 | 0 | 0 | 0.921296296 | 0 | 0.041935484 | 0 | 0 | 0 | 441.5841827 | 0 | 0 |
| 2017 | 6 | 98 | 0 | 0 | 0.93452248 | 171.5 | 0.041935484 | 0 | 0 | 0 | 441.5841827 | 0 | 0 |
| 2017 | 6 | 106.7777778 | 0 | 0 | 0.946204968 | 294.25 | 0.085990338 | 0 | 0 | 0 | 212.4310275 | 0 | 0 |
| 2017 | 6 | 114.6666667 | 0 | 0 | 0.977207482 | 316.25 | 0.085990338 | 0 | 0 | 0 | 212.4310275 | 0 | 0 |
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?
| Category | Months | |||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | AVG | ||
| Calls | 103 | 109 | 106 | |||||||||||
| Survey Count | 19 | 4 | 11.5 | |||||||||||
| Driver Score | 97.6% | 93.2% | 95.4% | |||||||||||
| Survey Score | 289 | 288 | 288.5 | |||||||||||
| Survey Incentive | $131.84 | $136.25 | $134.05 | |||||||||||
| Driver Score | 97.6% | 97.7% | 97.7% | |||||||||||
| Batteries Sold | 18 | 19 | 18.5 | |||||||||||
| Member Testing Rate | 83.0% | 91.0% | 87.0% | |||||||||||
| Conversion Rate | 62.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 |
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. ![]()
Regards
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.