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 created by DAX)

Dynamic count: 9211 (in Table 2)

 

Now I am trying an alternative way (but also failed), display the text and count in 2 different Card visual:

For Date card, a measure was created:

SelectedMonthYear = SELECTEDVALUE('Date'[Month]) + SELECTEDVALUE('Date'[Year])

But when I select May, 2023, it was displaying 2023 instead of May2023.

 

Any advice is appreciatd.

H

 

 

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])

2 Replies

  • amitchandak's avatar
    amitchandak
    Super 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