Forum Discussion

Steamedbunz's avatar
Steamedbunz
Frequent Visitor
1 year ago
Solved

Matrix Visual Continuous Table, not summed Months

Hi All, 

 

I have this Matrix Visual where the rows are broken up into States, and the columns are date hierarchy. When it is Drilled to the upper level of columns it is perfectly fine. However, when you drill down the column into 'Months', it will show the 12 months but all values added up between the years. Is there a way it can display the table as continous with years separated? I've provided a demonstration table in Excel. 

1. Upper most Drill on Column.

 

2. Column Drill down to months, but slicer only selecting 2024 and 2025.

 

3. Example continous table in Excel. 

 

 

 

Regards, 

  • Figured out myself. Instead of using the Date Hierarchy from the Time Dimension table. 

    Setup another "YearMonthShort", FORMAT ( [Date], "mmm/YYYY" ), and use this for the columns in the Matrix. 

     

     

2 Replies

  • Steamedbunz's avatar
    Steamedbunz
    Frequent Visitor

    Figured out myself. Instead of using the Date Hierarchy from the Time Dimension table. 

    Setup another "YearMonthShort", FORMAT ( [Date], "mmm/YYYY" ), and use this for the columns in the Matrix. 

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi, Steamedbunz 

       

      I'm very glad you solved the issue you were having yourself and shared the solution.

       

      I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
      Best Regards,
      Fen Ling,
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.