Forum Discussion
Fixed Matrix Layout when data unavailable
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
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.
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,