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
Super 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
)

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Super! ! !

 

let me try 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous ,

     

    Pls has your problem been solved? If so, accept the reply as a solution. This will make it easier for the future people to find the answer quickly.

    If not, please provide a more detailed description, preferably some dummy sample data, and the expected results.

     

    Best Regards,

    Stephen Tao