Forum Discussion

ritanoori's avatar
ritanoori
Resolver I
7 years ago

Dynamic coulmn headers based on slicer

Hello I 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...
Need Help
Tips and Tricks
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi ritanoori 

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

 

Best Regards
Maggie

 

 

ritanoori's avatar
ritanoori
Resolver I
7 years ago

Hi Maggie 

"CY Plan, CY-1 Actual" are measures correct.

Here it is

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi ritanoori 

    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

     

     

    Best Regards
    Maggie