cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ITManuel
Helper V
Helper V

Column granularity in matrix

Hi,

 

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

Column granularity in Matrix.JPG

 

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

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@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



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

PaulDBrown
Super User
Super User

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... 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

2 REPLIES 2
PaulDBrown
Super User
Super User

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... 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






amitchandak
Super User
Super User

@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



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors