The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to Solution.
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 @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!
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!
Thanks, I will try it and I'll get back to you !!
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/
User | Count |
---|---|
86 | |
84 | |
35 | |
35 | |
35 |
User | Count |
---|---|
94 | |
79 | |
63 | |
55 | |
52 |