Dynamic coulmn headers based on slicer

Question

HelloI have below matrix which shows calculated measures for previous period of time. The values are dynamically changing based on the selection of year and month in Slicers. Is there a way that we make coulmn headers to change dynamically as well? so if we select year 2019, the CY Plan will be changed to 2019 Plan instead of CY Plan, CY-1 Actual will changed to 2018 Actual.&nbsp;Many thanks in advance.&nbsp;

v-juanli-msft · Answer

Hi&nbsp;ritanoori&nbsp;
"CY Plan, CY-1 Actual" are measures, right?
Could you show an screenshot of the matrix fields ?
(show me which columns or measures added to its "Row","Column","Value"fields).
&nbsp;
Best RegardsMaggie
&nbsp;
&nbsp;

ritanoori · Answer

Hi Maggie&nbsp;"CY Plan, CY-1 Actual" are measures correct.Here it is

v-juanli-msft · Answer

Hi&nbsp;ritanoori&nbsp;
there is no way to rename name of a measure dynamically based on a slicer.
How about this kind of visual?

year
quarter
product
CY plan
CY-1 plan
CY Actual
CY-1 Actual

2018
1
a
1
2
1
2

2018
2
a
2
3
2
3

2018
3
a
3
4
3
4

2018
4
a
4
5
4
5

2019
1
a
5
6
5
6

2019
2
a
6
7
6
7

2019
3
a
7
8
7
8

2019
4
a
8
9
8
9

&nbsp;
&nbsp;
Best RegardsMaggie

Forum Discussion

Dynamic coulmn headers based on slicer

3 Replies

Related content

Dynamic Column headers

Dynamic Column Header in Visualisation

Dynamic Headers in DAX

Dynamic header

Dynamic Column Header In a Matrix

year	quarter	product	CY plan	CY-1 plan	CY Actual	CY-1 Actual
2018	1	a	1	2	1	2
2018	2	a	2	3	2	3
2018	3	a	3	4	3	4
2018	4	a	4	5	4	5
2019	1	a	5	6	5	6
2019	2	a	6	7	6	7
2019	3	a	7	8	7	8
2019	4	a	8	9	8	9