Fixed Matrix Layout when data unavailable

[ADSL]

Hi BI Community Team,

I have a sales data and build the matrix table to see the performance for full year 2024 & 2025. However, matrix table layout will change when choose the year because data is not full yet for 2025 as the screenshot below.

Any suggestion/advise how to fixed the layout even data is unavailble? I mean header will be showing Jan | Feb | -- | Dec, and value is zero (0) if unavailable of data.

Expectation result:

Thanks and Regards,

[ADSL]

Hi All,

Thank you for your time and feedback.

Best Regards,

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file whether it suits your requirment.

Show items with no data in Power BI - Power BI | Microsoft Learn

[DataNinja777]

Hi @ADSL ,

Is there any reason to duplicate the matrix table into separate tables for 2024 and 2025? Why not combine them into a single matrix table to also resolve the issue of missing data?

Best regards,

[ADSL]

Hi @DataNinja777 ,

We're tracking by year and selection but just have issue of layout that is changing when select.

I don't have any solution to fixed this layout as the expection result below even year selection is choose.

[DataNinja777]

Hi @ADSL ,

To prevent Power BI matrix visuals from hiding future months with zero or null values, ensure your Calendar table covers the entire desired period, such as all of 2025. Use a measure like:

Sales with Zeros = IF(ISBLANK(SUM(Sales[Amount])), 0, SUM(Sales[Amount]))

This replaces blanks with zero, ensuring months with no data remain visible. Additionally, enable “Show items with no data” by right-clicking the relevant field in the Fields pane.

For a more comprehensive solution, use CROSSJOIN to generate all combinations of months and categories, or create a measure to display zeros for future dates:

Future Sales = IF(MAX('Calendar'[Date]) > TODAY(), 0, [Sales with Zeros])

These steps ensure your matrix visual includes future periods, even if they have no data.

Best regards,