Forum Discussion

aogata's avatar
aogata
Frequent Visitor
9 years ago
Solved

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 qua...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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:

aogata's avatar
aogata
Frequent Visitor
9 years ago

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)

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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:

  • aogata's avatar
    aogata
    Frequent Visitor
    9 years ago

    Nice! thank you