Calculation groups & Column Hierarchy

Hi PierreL69,

I have 3 Approaches For you 😀❤️

First One : Enable "Show Items with No Data"

• Select your matrix visual

• Go to Format pane → Values section

• Turn ON "Show items with no data"

• This often forces Calculation Groups to appear at all levels

Second Approach: 

• Instead of using the automatic date hierarchy, add columns individually, In your matrix columns field:

Year
Quarter  
Month
Calculation Group

• This creates a flat structure where the Calculation Group is always visible at every level.

Third Approach : 

• Modify your calculation items to handle different hierarchy levels (DAX):

Sales Amount Calc = 
SWITCH(TRUE(),
    ISINSCOPE('Date'[Month]), [Sales Amount],
    ISINSCOPE('Date'[Quarter]), [Sales Amount],
    ISINSCOPE('Date'[Half]), [Sales Amount],
    [Sales Amount]
)

Bonus Approach : 

• Create a field parameter for your time hierarchy and use it alongside the Calculation Group in columns.