Filter SharePoint List using date range

[smuntimadugu]

In Power Bi User want to filter data from SharePoint list by choosing From Date and To Date. Is there any way to achieve this.

I tried using Time slicers, but it didn't gave me any option to pick From and To Date.

I had a look at parameters, but couldn't find a way to present those parameters for user for choosing From and To date.

Any pointers to achieve Date Range filters for SharePoint data would be very helpful.

[v-jiascu-msft]

@smuntimadugu

Hi,

Do you have the latest Power BI Desktop. If you had, you would try the slicer with between. @Greg_Deckler is right.

Best Regards!

Dale

[smuntimadugu]

I did downloaded latest PowerBi, still i didn't get date pickers. Am I missing anything?

[v-jiascu-msft]

@smuntimadugu

Hi,

When do you want to do the “Filter”? When you get data from SharePoint or you create report? Date slicer (date picker) is a visualization. You can see it in the red square in the picture. Hope this helps.

 

Best Regards!

Dale

[Greg_Deckler]

Are your From and To dates in different columns? If the from and to dates that you are trying to filter to are in the same column, a simple date slicer will work. You could also try visual filters.