Forum Discussion
How to create a date slicer
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?
Anonymous ,
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/
Hello Anonymous ,
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!
4 Replies
Anonymous ,
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/
Hello Anonymous ,
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!