Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |