Dynamic display text with fixed text

[Anonymous]

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

[amitchandak · Accepted solution]

@Anonymous , not very clear. But it should be like

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

[Anonymous]

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