cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JamesCH
Frequent Visitor

How do i allow someone enter start date and finish Date

Hi

 

I have a number of reports / visualisations that are replacements for current web pages. On the old systems the people using them were able to select a Start Date and End Date on the screen either by typing it in or by using a calander picker.

 

The data and graphs on the screen then reflected this.

 

I have not really seen anything like this in Power BI so hope that someone out there can point me in the right direction. This is a missing part that is stopping people using the system at the moment

 

thanks

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft
Microsoft

Hi @JamesCH,

In Power BI Desktop, you can consider to use Advanced filter of Visual level filters/Page level filters/Report level filters. With Advanced filter, you can select a start date and end date to filter reports and visualizations. Besides, selecting a date range in Timeline slicer will have same effect on your visualization. There is an example for your reference.
1.PNG


In addition, the difference among Visual level filters, Page level filters and Report level filters are as follows, choose them based on your needs.

1. Visual level filters - these filters limit the data shown only within the selected visualization
2. Page level filters - all the visualizations on a particular page have their results limited
3. Report level filters - all visualizations on the report have their data restricted by the filter criteria

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yuezhe-msft
Microsoft
Microsoft

Hi @JamesCH,

In Power BI Desktop, you can consider to use Advanced filter of Visual level filters/Page level filters/Report level filters. With Advanced filter, you can select a start date and end date to filter reports and visualizations. Besides, selecting a date range in Timeline slicer will have same effect on your visualization. There is an example for your reference.
1.PNG


In addition, the difference among Visual level filters, Page level filters and Report level filters are as follows, choose them based on your needs.

1. Visual level filters - these filters limit the data shown only within the selected visualization
2. Page level filters - all the visualizations on a particular page have their results limited
3. Report level filters - all visualizations on the report have their data restricted by the filter criteria

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

fantastic thanks that will do nicely

Habib
Responsive Resident
Responsive Resident

In current version, there is no option available for input field but you can achieve this using slicers. For this you need to add dimension in your data model and then use the dates in slicer.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors