How to create a date slicer

[sunnycarrandi]

hi friends,

I have several date columns in my SharePoint list, when I add created as a filter I can not get it to behave like a slicer, it only shows as the screenshot below. Any ideas on how to fix this? 

[Tahreem24 · Accepted solution]

@sunnycarrandi , 

Just click on the down arrow of this slicer and choose date between option so it will show the Date Range slicer. 

Or click on the Date field of the slicer from visualization pane and click on Date Hierarchy so it will also show the date format value. 

Visit this link:

https://www.enhansoft.com/how-to-create-a-power-bi-date-range-slicer/

[Shishir22 · Accepted solution]

Hello @sunnycarrandi ,

Make sure you are pulling Date field instead of individual hierarchy. And from the down arrow, select between/after/before as reqired. Hope below picture will help you.

Please mark it as solution/give kudos if it helped you.

Thanks! 

[sunnycarrandi]

Dear @Shishir22 ,

The solution worked, thanks 🙂 

[sunnycarrandi]

Thanks, I will try it and I'll get back to you !! 

[Tahreem24 · Accepted solution]

@sunnycarrandi , 

Just click on the down arrow of this slicer and choose date between option so it will show the Date Range slicer. 

Or click on the Date field of the slicer from visualization pane and click on Date Hierarchy so it will also show the date format value. 

Visit this link:

https://www.enhansoft.com/how-to-create-a-power-bi-date-range-slicer/