Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX for changing column header name with filter

PlanetsQuarterYearVolume
Mars1Q20215
Mars2Q20216
Mars3Q20217

 

I am looking for a DAX were if I select QuarterYear in Slicer = 1Q2021 the column name in table for volume should change to "1Q2021 Volume".

  • Anonymous Column headers do not support conditional text. Only thing I can think of would be to create a measure that returns your dynamic text. Overlay that card over your column header and change your column header to be some kind of non-printing character. Messy.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Anonymous Column headers do not support conditional text. Only thing I can think of would be to create a measure that returns your dynamic text. Overlay that card over your column header and change your column header to be some kind of non-printing character. Messy.

    • Anonymous's avatar
      Anonymous
      Not applicable

      okay. i wasnt finding any conditional formating option and nothing on the net. just wanted to know if its doable.
      Thanks!!!