Forum Discussion

saiduluvaddelli's avatar
saiduluvaddelli
Frequent Visitor
7 years ago
Solved

Dynamic Column Name change Based on Slicer Selection

Any one could you please help me on  Dynamic Column Name change Based on Slicer Selection.

below is the senario.

 

Matrix visual 

School NameAcademic Year 
XXX56
YYY87
ZZZ78
  

 

Slicer Selection 

 

Year 
2016-17
2017-18
2018-19
2019-20

 

when i slecet year 2017-18 , column name on matrix should change dynamicaaly as Academic Year 2017-18 .

 

3 Replies

  • Cmcmahan's avatar
    Cmcmahan
    Resident Rockstar

    You can't really do this in PowerBI, but you can try a workaround, like the one described here.

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support

    Hi saiduluvaddelli,

     

    We can set conditional formatting of tile of the matrix based on the measure as below to work arounmd.

     

    Measure = "Academic" & SELECTEDVALUE(Slicer[Year ])

     

    • saiduluvaddelli's avatar
      saiduluvaddelli
      Frequent Visitor

      Hi v-frfei-msftCmcmahan  ,

      Thank you for the update , given workaround is for title change for the respective vidualization but not the column name dynamic change , please help me if any other solutions .