Forum Discussion
consistent display of multiple text fields
Gotcha, well we can use CALCULATE() to solve this problem. I'm curious if it can be done easier, though. Anyway, this works:
Latest Date = CALCULATE(MAX(MuhDates[Comment]), FILTER(MuhDates, MuhDates[Date] = MAX(MuhDates[Date])))
Let's see if this forum allows GIF images:
If you're working specifically with dates, you can create a measure for the text you're after and display that in a card. I've done this a few times.
FIRSTDATE()/LASTDATE() would get you the information. From here, you can use FORMAT() to get it how you want it, such as having long text month names or 2-digit years.
I'll test it as suggested, but I thought I'd clarify what I'm after (just to make sure)
If my data looks like this:
date comments
May1 first day
May2 second day
May3 third day
May4 fourth day
May5 fifth day
And I have 2 visualizations:
A slicer for date selection
A card for comment display
If I select dates: May2, May4 & May5, I would like for the card to consistently display "fifth day" (the comment associated with the latest date)
Gotcha, well we can use CALCULATE() to solve this problem. I'm curious if it can be done easier, though. Anyway, this works:
Latest Date = CALCULATE(MAX(MuhDates[Comment]), FILTER(MuhDates, MuhDates[Date] = MAX(MuhDates[Date])))
Let's see if this forum allows GIF images:
Nice! thank you