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.
I have the following matrix (I simplified it) :
I want when I select the months for the 2020 year, the name of the column Year becomes Year 2020
so that column is dynamically modified depending on the year selection.
and the next column will be Year N-1 which is Year 2019.
How can I achieve that ?
Solved! Go to Solution.
Hi @amirabedhiafi ,
Such an output is not available. I'd suggest you put Year to Row field in matrix visual instead.
1. Add a Year column to your table.
Year = "Year "& YEAR([Date])
2.Create a Calendat table for slicer.
Calendar = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))
3.Apply below measure to filter pane, set as "is 1":
Measure =
var _selectYear=SELECTEDVALUE('Calendar'[Date].[Year])
return IF(YEAR(MAX('Table'[Date]))=_selectYear || YEAR(MAX('Table'[Date]))=_selectYear-1 ,1,0)
4.Drag [Cate] to Column field, [Year] to Row field:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @amirabedhiafi ,
Such an output is not available. I'd suggest you put Year to Row field in matrix visual instead.
1. Add a Year column to your table.
Year = "Year "& YEAR([Date])
2.Create a Calendat table for slicer.
Calendar = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))
3.Apply below measure to filter pane, set as "is 1":
Measure =
var _selectYear=SELECTEDVALUE('Calendar'[Date].[Year])
return IF(YEAR(MAX('Table'[Date]))=_selectYear || YEAR(MAX('Table'[Date]))=_selectYear-1 ,1,0)
4.Drag [Cate] to Column field, [Year] to Row field:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@amirabedhiafi I am not aware of a way to make column headers dynamic like that unless you perhaps overlayed them with card visualizations that you used measures in.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |