Column granularity in matrix

[ITManuel]

Hi,

I have a matrix with a Year/Months Hierarchy on the columns. 

Is there any possiblity to show the current year 2021 with current Year/Months hierarchy and any following years starting from 2022 only on the year level?

Best regards

[amitchandak · Accepted solution]

@ITManuel , You need to create a new column like

if([Date] >date(year(today()),12,31) , "All", [Month] )

This will group all month into one group

[PaulDBrown · Accepted solution]

Option 1: You can manually hide the month columns by dragging the right column boundary (you need to turn off word wrap in the formatting options) for each of the redundant months

Option 2: create a custom matrix layout:

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1... 

[amitchandak · Accepted solution]

@ITManuel , You need to create a new column like

if([Date] >date(year(today()),12,31) , "All", [Month] )

This will group all month into one group