cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JamesCH Frequent Visitor
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

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: How do i allow someone enter start date and finish Date

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.
3 REPLIES 3
Highlighted
Habib Established Member
Established Member

Re: How do i allow someone enter start date and finish Date

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.

Moderator v-yuezhe-msft
Moderator

Re: How do i allow someone enter start date and finish Date

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.
JamesCH Frequent Visitor
Frequent Visitor

Re: How do i allow someone enter start date and finish Date

fantastic thanks that will do nicely

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 283 members 3,003 guests
Please welcome our newest community members: