Forum Discussion
consistent display of multiple text fields
I would like to display some informational comments associated with my dataset.
Imagine that you use a slicer to select a date datapoint. It is associated with the text string: "first day for quarterly report".
I can use a card visualization to display the text string.
My problem occurs when selecting multuple datapoints through the slicer.
The card seems to randomly choose which string to display.
Ideally, I'd like to see:
1- display ALL strings selected (would need a scroll bar)
2- display the FIRST or LAST string (since the datapoints are dates, it could take that into account)
Is there a way to do this with either basic or custom visualizations?
4 Replies
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)
