Forum Discussion

SK87's avatar
SK87
Helper III
4 years ago
Solved

Dynamic column based on slicer selection

Hi Team,   I have Slicer for Month-Year (Column name as select month). and have created Matrix table for 12 Months where will see sum of searches of last 12months from latest month. Now I need to s...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi SK87 ,

    If you want your field name to be displayed dynamically based on the slicer options, I'm afraid it can't be achieved... Maybe you could consider creating a measure as below and putting it on the card visual to display the field name info...

    measure =
VAR _selmonth =
    SELECTEDVALUE ( 'Brands Final'[Select Month] )
RETURN
    "12M (" & [the month for 10 months ago] & " - " & _selmonth & ")"

    Best Regards