Matrix Visual Column Limit Issue

[coombech]

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.

[Millerwa]

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!

[amitchandak · Accepted solution]

@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

[coombech]

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.