Forum Discussion
JoeCrozier
Helper II
Helper IIDisplay Card with date range from selected slicer
I think I need to do exactly this solution from this question, but honestly I just need it explained a bit more. More detail: I have these slicers on one tab of my Power bi: And on th...
JoeCrozier Oh, for that I would just use this:
Measure = VAR __MaxStatus = MAX('Staff'[Status Date]) VAR __MinStatus = MIN('Staff'[Status Date]) RETURN __MinStatus & " - " & __MaxStatus
JoeCrozierHelper II
Helper IIGreg_Deckler Thank you! So just to make sure I understand, lets say I have this selected in the slicer on the first page:
And I create a measure that looks like this:
And I put that measure on this card:
I would expect/hope for that card to say:
"4/18/2010 - 8/20/2018"
But it doesn't. Clearly I'm doing something wrong or didn't communicate it well. Can you spot what I did?
Greg_Deckler
Community Champion
Community ChampionJoeCrozier Oh, for that I would just use this:
Measure =
VAR __MaxStatus = MAX('Staff'[Status Date])
VAR __MinStatus = MIN('Staff'[Status Date])
RETURN
__MinStatus & " - " & __MaxStatus- JoeCrozier
Im sorry to keep drawing you back in (and I really really appreciate all the help!) but it still seems to not be working:
Any ideas?