How to make date slicer with slider only display 1st and last days in a month

[Anonymous]

I have a date slicer set as a slider. I want users to select a start date and end date. I want the users to only be able to select the 1st of the month for the Start date, and the last day of a month for the End date. To achieve this, I have added a field IsFirstOrLastDayOfMonth to my dimDate table and filtered the slicer visual to IsFirstOrLastDayOfMonth = Y. 

But the slicer slider still allows users to select dates that have IsFirstOrLastDayOfMonth = N!

How can I achieve this?

[ara0530]

so in other words, what he is asking is not possible?  I have a similar need I only want to see the first of the month as the slicer moves, not every day

[Anonymous]

Hi @Anonymous ,

According to your description, I created some data to show:

1. Generate a date range slicer and a slicer with month as list.

2. Select the date range slicer, open the format on the home page, select Edit interactions, and select the filter option for slicers with month as list.

3. Result.

Select a month of the slicer with month as the list, and the date range slicer will only display the first and last days of the selected month

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix]

Hi @Anonymous ,

You cannot set the select of the two values in the slicer in an individual believe that the best option would be to create a hierarchy slicer with year month.

[Anonymous]

I don't understand the first part of your sentence. 

How would a hierarchy slicer allow a user to select a Start month and an End month, but without having to select every month in between? I think I'm missing something very simple.

[amitchandak]

@Anonymous , I think this because of range slicer. Convert to list and check

[Anonymous]

I want it to be a range slicer. I don't want the users to have to scroll through a list of months