Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
But when I select May, 2023, it was displaying 2023 instead of May2023.
Any advice is appreciatd.
H
Solved! Go to Solution.
@h_l , not very clear. But it should be like
SelectedMonthYear = SELECTEDVALUE('Date'[Month]) & "/" & SELECTEDVALUE('Date'[Year])
@h_l , not very clear. But it should be like
SelectedMonthYear = SELECTEDVALUE('Date'[Month]) & "/" & SELECTEDVALUE('Date'[Year])
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