Forum Discussion
Matrix Visual Column Limit Issue
Hello, I have developed a Leave PowerApp for my organisation and have embedded a Power BI report showing employee leave entitlement and leave taken along with a calendar showing each employee's leave type for the year. I have used the matrix visual for the latter, however because of the column limitation of this visual, I can't display all 365 days. I have used slicers to split the data into quarters which is within the 100 column limit of the visual, however my manager isn't satisfied with this resolution.
Is there another alternative visual I could use that would display all 365 days and keep the layout as per the matrix visual? I dont think the table visual would work because it's tabular and wouldn't give me the column hierarchy as per the matrix. Please see the screenshot below of how my matrix visual currently looks...
Any help would be greatly appreciated.
coombech , for the limit you can log an idea -Ideas.powerbi.com/
Custom Visual you can check here
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
3 Replies
- amitchandak
Super User
coombech , for the limit you can log an idea -Ideas.powerbi.com/
Custom Visual you can check here
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
Thank you, will log the issue with matrix visual column limit at the link provided. Will take a look at custom visuals to identify any alternatives.
1. combine days together as week, so a year contain ~50 weeks, far less than 100.
2. switch/pivot column and row for your visual.
3. use 3rd party matrix visual, instead of the native matrix.
4. code your matrix visual!
