Date slicer in months

[admin_xlsior]

Hi guys,

Can we make a slicer per month with the "slider" style ?

This kind of "slider" ->

This is a "Before" slicer, but I want to be in months only, and most importantly the date in the end is the last day of this month.

So instead 12/10/2021, it should be 12/31/2021. The source of this is my Date Dimension, which have dates up to year 2024.

Is it possible ? FYI, it is good if can be by months, but if not, my objective is to have the slicer end with last day of this month.

Thanks

[Anonymous]

Hi @admin_xlsior 

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

If no , please provide your need in detail .

Best Regard

Community Support Team _ Ailsa Tao

[Anonymous]

Hi @admin_xlsior 

I don't quite understand your needs .If you just want to return the last day of the month when you select the date ,you can use EOMONTH DAX to get the result you want .

Measure = EOMONTH(SELECTEDVALUE('Table'[Date]),0)

Best Regard

Community Support Team _ Ailsa Tao

[amitchandak]

@admin_xlsior , I doubt that is possible.

You can create an independent  date slicer and use month year and make it work like that

// Date1 in independent table Date is joine table
out =
var _max = maxx(allselected(Date1), Date1[Date])
return
calculate(sum(Table[Value]), Filter(Date,Date[Date] <=_max ) )

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

[admin_xlsior]

Hi @amitchandak 

I'm sorry, I looked at your video but not really understand it. 

First of all, the 1st slicer looks promising, by using Last N year with Calendar, but to use this makes the date is the date of last year ->

If I didn't choose "(Calender)", it will goes back as of today's date.

So how to make it 12/31/2021 ?

Further more, if lets say today is November 2021, I would like the date is up to 11/30/2021 instead. Point is the slicer should be up to last day of the current month.

Thanks

Thanks,