Seeing selected date range in a card visual

Anonymous — Tue, 28 Nov 2023 14:56:30 GMT

I want to show a card visual on the home page of the repport that shows the YearMonth range selected in the filter pane.

I have a DimDate[MonthYear] filter on all pages and have a current selection of Jan/19 until Oct/19. This is what i want displayed in my card visual as "Jan/19 - Oct/19". Ofcourse the visual had to change depending on the filter that changes. I already have the following DAX formula but this one gives me "Oct/19 - Oct/19". I can't figure out what i have to change to get my desired outcome.

Selected YearMonth =

VAR MinYearMonth = CALCULATE(

SELECTEDVALUE(Dim_Date[Month Year]),

FILTER(Dim_Date, Dim_Date[YearMonth] = MIN(Dim_Date[YearMonth]))

)

VAR MaxYearMonth = CALCULATE(

SELECTEDVALUE(Dim_Date[Month Year]),

FILTER(Dim_Date, Dim_Date[YearMonth] = MAX(Dim_Date[YearMonth]))

)

RETURN

MinYearMonth & " - " & MaxYearMonth

Re: Seeing selected date range in a card visual

Sahir_Maharaj — Wed, 29 Nov 2023 11:56:21 GMT

Hello Anonymous,

Can you please try this:

Selected YearMonth Range = VAR MinYearMonth = CALCULATE( MIN(Dim_Date[YearMonth]), ALLSELECTED(Dim_Date) ) VAR MaxYearMonth = CALCULATE( MAX(Dim_Date[YearMonth]), ALLSELECTED(Dim_Date) ) RETURN IF( MinYearMonth <> MaxYearMonth, FORMAT(MinYearMonth, "MMM/YY") & " - " & FORMAT(MaxYearMonth, "MMM/YY"), FORMAT(MinYearMonth, "MMM/YY") )

Hope this helps - If you have any questions, please do not hesitate to reach out to me.

topic Seeing selected date range in a card visual in DAX Commands and Tips

Seeing selected date range in a card visual

Re: Seeing selected date range in a card visual