Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic display text with fixed text

Hi there,   Just wanted to ask if there is a way to create card with dynamic selected text AND fixed text. As following sample shows: Fixed text: Order in: Dynamic text: May 2023 (in Date Table ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , not very clear. But it should be like

    SelectedMonthYear = SELECTEDVALUE('Date'[Month]) & "/" & SELECTEDVALUE('Date'[Year])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , not very clear. But it should be like

SelectedMonthYear = SELECTEDVALUE('Date'[Month]) & "/" & SELECTEDVALUE('Date'[Year])

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi amitchandak , nice to get your reply again, you've provided great helps in the past.

    It was almost done by using your advised DAX, however, it displays 5 2023 instead of May 2023.

     

    I tried to Format the text, but after DAX updated, it always display Jan 2023, not selected month.

    DAX: 

    SelectedMonthYear = FORMAT(SELECTEDVALUE('Date'[Month]),"MMM") & " " & SELECTEDVALUE('Date'[Year])

     

    Could you help to give a little further advice?

    Thanks.

    H