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