Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Select All in slicer

Hi , I have a requirement in my PBI report. In a filter panel Month filter ,If I select months it should give me Max of selected month,If i dont select any month it shd give default month as curren...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    Anonymous , To achieve the desired result please update dax as below

     

    SlicerSelection1 =
    VAR SelectedMonths = VALUES(CalendarTable[Month Year])
    VAR MaxMonth = MAX(CalendarTable[Month Year])
    VAR DefaultMonth = FORMAT(EDATE(TODAY(), -2), "Mmm-yy")
    VAR MaxSelectedMonth = FORMAT(MAX(SelectedMonths), "Mmm-yy")

    RETURN
    IF (
    ISFILTERED(CalendarTable[Month Year]),
    IF (
    COUNTROWS(SelectedMonths) = COUNTROWS(ALL(CalendarTable[Month Year])),
    "Selected Month by: " & MaxMonth,
    "Selected Month by: " & MaxSelectedMonth
    ),
    "Selected Month by: " & DefaultMonth
    )

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

Anonymous , To achieve the desired result please update dax as below

 

SlicerSelection1 =
VAR SelectedMonths = VALUES(CalendarTable[Month Year])
VAR MaxMonth = MAX(CalendarTable[Month Year])
VAR DefaultMonth = FORMAT(EDATE(TODAY(), -2), "Mmm-yy")
VAR MaxSelectedMonth = FORMAT(MAX(SelectedMonths), "Mmm-yy")

RETURN
IF (
ISFILTERED(CalendarTable[Month Year]),
IF (
COUNTROWS(SelectedMonths) = COUNTROWS(ALL(CalendarTable[Month Year])),
"Selected Month by: " & MaxMonth,
"Selected Month by: " & MaxSelectedMonth
),
"Selected Month by: " & DefaultMonth
)