Forum Discussion
Having a problem with creating a report using a matrix template - Help!!!!
I have built a report using the matrix template in Power BI. The report has all of the data (rows and columns) but I am having a problem with the wat the report is displaying the columns. three coulmns that I want anchored. The table I am showing is how I want my report to look. The 2nd table is what I am getting using the Matrix template provided in Power BI. Is there a way, or another template that I can use to achieve the look of the first table?
| Company | 1st Shift Qual count | 2nd Shift Qual Count | Company Qual Count | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 |
| Employee Type | |||||||||||||||
| Qual Type |
| Q-Month | Month 0 | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||||||||||||||||||||||||||
| Unit | 1st Shift Qual count | 2nd Shift Qual Count | Employee Qual Count | 1st Shift Qual count | 2nd Shift Qual Count | Employee Qual Count | 1st Shift Qual count | 2nd Shift Qual Count | Employee Qual Count | 1st Shift Qual count | 2nd Shift Qual Count | Employee Qual Count | 1st Shift Qual count | 2nd Shift Qual Count | Employee Qual Count | 1st Shift Qual count | 2nd Shift Qual Count | Employee Qual Count | 1st Shift Qual count | 2nd Shift Qual Count | Employee Qual Count | 1st Shift Qual count | 2nd Shift Qual Count | Employee Qual Count | 1st Shift Qual count | 2nd Shift Qual Count | Employee Qual Count | 1st Shift Qual count | 2nd Shift Qual Count | Employee Qual Count | 1st Shift Qual count | 2nd Shift Qual Count | Employee Qual Count | 1st Shift Qual count |
2nd Shift Qual Count | Employee Qual Count | 1st Shift Qual count | 2nd Shift Qual Count | Employee Qual Count |
| Company | |||||||||||||||||||||||||||||||||||||||
| Employee Type | |||||||||||||||||||||||||||||||||||||||
| Qual Type |
2 Replies
- AnonymousNot applicable
Hi bkanderso ,
To achieve the visual you want, there are 2 ways:
You can create a visual by yourself.
Power BI Custom Visuals – Data Visualisation Tools | Power BI (microsoft.com)
Now Power BI visuals are by design. Or you can create an idea here.
If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output with more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- bkanderso
Helper I
Thank you.