topic Re: default Slicer in DAX Commands and Tips

default Slicer

AzaharoddinSk — Thu, 22 Dec 2022 07:43:22 GMT

We have 4 years of data i.e from the past three years and a year of future data.

we need to add a slider slicer to the date field. The slicer should be selected default for the current month (MTD) is this possible by not adding an additional column in the calendar table?

Re: default Slicer

ValtteriN — Thu, 22 Dec 2022 08:38:07 GMT

Hi,

Here is one way to do this:

Add this column to your calendar:

This Month =

var TW = DATEDIFF(TODAY(),'Calendar'[Date],MONTH)

return

If(TW=0,"Current Month",'Calendar'[Month]

)

Then use that as a slicer:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Re: default Slicer

AzaharoddinSk — Thu, 22 Dec 2022 09:05:00 GMT

ValtteriN, The requirement is I want a total 4 years of data in the slider slicer, and by default, it can only show the current month's data, and when I move that slider it can show as per selected dates in 4 years of data, is that possible?

Re: default Slicer

ValtteriN — Thu, 22 Dec 2022 10:18:12 GMT

AzaharoddinSk I see, In that case there isn't an easy solution. You can default a slider to have values for only current month from the filter pane, but having a slider show automatically current month and then without users changing anything in the filter pane they could select values from last 4 years. This kind of combination of logics isn't really possible by only using a slider.