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

Creating Date scrolling within Power BU

Hi all,

 

Maybe I'm not seeing it, but I am not seeing the capabilitiy in Power BI of setting a date filter that I can scroll through.  I want to be able to navigate through my chart by clicking an up or down button to navigate through a 12-month period of data.  For example, if I have 36 months of data, with a 12 month view, I want to be able to navigate through this filter using an up or down control button, so that when I am on June, I can click up to start at July, or down to start at May.

 

Thanks for any input!

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team AlexGorev
Power BI Team

Re: Creating Date scrolling within Power BU

You can only filter DateTime in your report using the filter as described in the previos posts. We do have a proper Time Slicing capability pretty high in our backlog. You can also check and leave your additional votes and comments in related feature request below.

 

https://support.powerbi.com/forums/265200-power-bi/suggestions/7865136-timeline-slicer-for-date-mont...

 

Thanks,

Alex.

5 REPLIES 5
andre
Advisor

Re: Creating Date scrolling within Power BU

if you drag a DateTime field into a filter area, you should then be able to use the calendar control to make your selection.

Capture.PNG

pflipper Frequent Visitor
Frequent Visitor

Re: Creating Date scrolling within Power BU

Thanks for you input Andre.

 

Instead of a calendar widget, which IMHO is better as a specific date selector, I was hoping for something more along the lines of this:

 

Date Navigation.jpg

 

This is an example of something created in Excel, but could as well have been easily created in Access.  Instead of a widget to select a specific date, there is a control to allow for selection for month or year, as well as a way for easy navigation through a month using a control to move the date back or forward.

 

In order for me to transition clients to utilize their underlying data in a more user friendly manner (using Power BI, perhaps), I was hoping that Power BI would provide something along these lines, or something similar (like a bar below that chart that would allow the user to move along a timeline).

 

Are you, or is anyone else reading this, aware of something like this in the current version of Power BI?  Or a way to create this?

 

Thanks for any additional input!

Power BI Team AlexGorev
Power BI Team

Re: Creating Date scrolling within Power BU

You can only filter DateTime in your report using the filter as described in the previos posts. We do have a proper Time Slicing capability pretty high in our backlog. You can also check and leave your additional votes and comments in related feature request below.

 

https://support.powerbi.com/forums/265200-power-bi/suggestions/7865136-timeline-slicer-for-date-mont...

 

Thanks,

Alex.

pflipper Frequent Visitor
Frequent Visitor

Re: Creating Date scrolling within Power BU

Hi Alex,

 

Many thanks for the reply and clarification.  When you say high, does that mean priority-high?  Meaning, a time slicer is going to be looked at sooner than other requests?

 

I will vote for it, too - thanks for the link!

Power BI Team AlexGorev
Power BI Team

Re: Creating Date scrolling within Power BU

I meant priority high... There are a still few other time related scenarios that we need to enable prior to this but we hope to work on this soon.

 

Thanks,

Alex.