Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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:
Proud to be a Super User!
Paul on Linkedin.
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:
Proud to be a Super User!
Paul on Linkedin.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |