Forum Discussion

ADSL's avatar
ADSL
Post Prodigy
1 year ago
Solved

Fixed Matrix Layout when data unavailable

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,

Need Help

5 Replies

  • DataNinja777's avatar
    DataNinja777
    Super User
    1 year ago

    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's avatar
      ADSL
      Post Prodigy
      1 year ago

      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's avatar
        DataNinja777
        Super User
        1 year ago

        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,

  • ADSL's avatar
    ADSL
    Post Prodigy
    1 year ago

    Hi All,

     

    Thank you for your time and feedback.

     

    Best Regards,