Help me with visualization

[tarunbisht20001]

Hello Everyone,

I have a requirement where the client wants a matrix-style view with 365 columns—one for each day of the year. The challenge is fitting all 365 days into a single view, as the client does not want to use any filters (e.g., by month) since it's forecast data and they want to see the entire year at once.

Could you please suggest an optimized way to achieve this?

Thanks in advance for your help!

[Vijay_Chethan · Accepted solution]

There seems to be a limitation with respect to number of columns that can be added to the matrix visual
you could use paginated matrix some what like this:
(6) UX Revolution with Visual Level PAGINATION in Power BI - YouTube

[v-hashadapu]

Hi @tarunbisht20001 , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[v-hashadapu]

Hi @tarunbisht20001 , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[azakir]

I agree with the all the answers, paginated report would be the way to go. 

Or, you can even extend the canvass width and try to do it with matrix visual. Going to look a bit hedious honestly with increased width but worth a try.

[v-hashadapu]

Hi @tarunbisht20001 , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answers that helped 'Accept as Solution', so others with similar queries can find them easily. If not, please share the details.
Thank you.

[ribisht17 · Accepted solution]

Hello @tarunbisht20001 

Creating a matrix-style view with 365 columns in Power BI can be challenging due to space and performance constraints. Here are some optimized approaches to achieve this:

1. Horizontal Scrolling:

   • Use the matrix visual and enable horizontal scrolling. This allows users to view all 365 columns without overwhelming the screen.
   • Adjust column width to fit more columns within the viewable area.

2. Dynamic Columns:

   • Create a measure that dynamically displays data for a specific range of days (e.g., 1–30, 31–60) based on user selection or slicers. While this doesn't use filters, it reduces the number of visible columns at once.

3. Paginated Reports:

   • Consider using Power BI Paginated Reports, which are better suited for handling large datasets and wide tables. Users can export the report to PDF or Excel for easier viewing.

4. Custom Visuals:

   • Explore third-party custom visuals from the Power BI marketplace that might support better handling of large matrices.

5. Optimize Data Model:

   • Aggregate data where possible to reduce the granularity. For example, instead of showing daily data, consider weekly or monthly summaries.

6. Split into Sections:

   • Divide the matrix into multiple visuals, each showing a portion of the year (e.g., Q1, Q2, etc.). This keeps the report manageable while still displaying all data.

You can find more insights on matrix visual formatting here and optimization techniques here. Let me know if you'd like detailed steps for any of these solutions!

Regards,

Ritesh Bisht

Community Champion

Please mark the answer if helpful so that it can help others

Dance-Sing with Data Projects - YouTube

[LED_General]

An idea would be to enlarge the canvas width of the page by a great amount.

[BhavinVyas3003]

Hi,

If your client wants to see all 365 days together without scrolling or filtering, then Power BI Paginated Reports might be good option. It can handle large tables and matrices very well.

Using report builder you can create paginated reports.

 You can design and preview paginated reports for free on your computer using Power BI Report Builder.

 But to publish and share online, Premium is required.

Thanks,

Bhavin

[Vijay_Chethan]

if it helps pls mark as solution

[Vijay_Chethan · Accepted solution]

There seems to be a limitation with respect to number of columns that can be added to the matrix visual
you could use paginated matrix some what like this:
(6) UX Revolution with Visual Level PAGINATION in Power BI - YouTube