microsoft / powerbi-visuals-timeline

Timeline slicer is a graphical date range selector used as a filtering component in the report canvas

Timeline Slicer

Graphical date range selector to use for filtering dates

Overview

The Timeline slicer is a graphical date range selector used as a filtering component in Power BI. This makes filtering data by date dimension easy and fun.

How often do you have to filter your data for a date range or at higher level such as month or quarter? Every single time. Right? Filtering is pain when you have to click through large numbers of date values to select the range you want. Changing the filter granularity from months, the quarters and years on the fly is super tedious. Well, it used to be super tedious.

The Timeline slicer is going to make this experience a breeze. With this simple slider control for dates, all you need to do, is just click and drag to the range that you want. You can also switch to a Year, Quarter or Month view to select ranges even at a higher level than dates.

You can simply click on the slicer to select a single value or click the edge and drag it to the range that you want.

You can also change the background & selection color and number of other formatting options to control the look-n-feel. SHIFT+Click also works for selecting a range.

See also Timeline Slicer at Microsoft AppSource

powerbi-visuals-timeline's Issues

The visual does not appear in the Aug on-premise power Bi report service

Timeline slicer not selecting the last month

When all the months available for selection are selected, the last month is not selected even though it is available for selection.

Ppwer BI desktop version: 2.49.4831.521 64-bit (August 2017)
Timeline slicer version: 1.4.5.0

Support for half year

I was able to add support for half years by using quarter year as a guide to add the relevant code - it would be good if this code was added to the official timeline visual as it's a pretty quick and easy enhancement

https://github.com/stugr/powerbi-visuals-timeline

Blank above the timeline

Hi,
When I want to keep only the timeline with months, I can't delete the blank above the timeline.
If I have others buttons, I can't click on them if the focus is on the timeline
Best regards

Idea: Allow syncing of timeline across pages using 'Sync Slicers'

With the 'Sync Slicers' feature, many slicers can be synced across pages. It would be great if we could somehow capture the Timeline slicer in this as well. Currently it is not possible to select Timeline objects with this feature.

Support for custom date hierarchy for year-month-week hierarchy

Hi all,

I have created a custom date hierarchy to always allocate full weeks to a month (basically the week goes to the month into which the 4+ days fall, similar to ISOWeek for the start of the year).

Is there an option to adapt the timeline slicer for that?

The current implementation of the timeline slicer doesn't work with custom hierarchies. As an alternative one could use the standard hierarchical slicer, but it works vertical instead of horizontal like the timeline slicer and doesn't provide the same ease of multi-select.

Example: Week 14 is not correctly allocated

Example: Week 53 doesn't exist in 2019

This repo is missing important files

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

Choose labels to display

Hi, i'm very grateful for the visualization. It's very useful.
I would like to be able to choose the labels to display.
For example, if I select the week granularity, I would like to only show the month and year label.

Thanks!

Issues with Timeline Slicer

I have a report which has three slicers on the page - Product, Release and third slicer is Timeline slicer.
And I created a custom visual in Deneb Vegalite.

I am facing following two issues with Timeline Slicer [@microsoft](

Problem 1: When I change the Product and Release slicers, timeline slicers period changes automatically with respect to that product/release which is not desirable. If I have earlier selected it for Q1 and Q2, it should stick to those selection instead of showing all ranges Q1, Q2, Q3 and so on if product /releases have dates.

Problem 2: After I change selection in Product and Release slicer, it automatically changes values in Timeline slicer but for some reason it doesn't refresh the Deneb visual. But as soon as I click on timeline slicer, visual gets refreshed. I suspect timeline slicer is not interacting well.

I dont think this is issue with Deneb visual as when I change to default slicer for Period, it works fine. So, to my understanding this problem is with Time slicer.

BUG with the component Timeline Slicer & Power BI Report Server

Hi !

Since I updated my Power BI Report Server and my Power BI Desktop with the september release, I can't use anymore the component Timeline Slicer.
It works perfectly with the desktop version (optimized for Report Server) but as soon as I publish my .pbix on Power BI Report Server, the visual timeline component appears but when I click on a date, it is not filtering my values in my table.

==> OK on Power BI Desktop
==> KO on Power BI Report Server

I use Power BI Report Server September 2019 / Power BI Desktop optimized for Report Server September and Timeline Visual 2.1.1.0.

Thanks for your help.

Timeline Slicer Force Selection

Hello,
When turning the Current Period option on in Force Selection of the Timeline Slicer, it is visually selecting the current month (we have month granularity) but the report is not reflecting the data related to the current period selection, instead it is showing the data for the old date selection (the date selected in the timeline slicer when the report was published), and also when I click on the filter pane the current period selection is getting back again to it's old selection which is really weird, could you help me with this issue please? is it a bug?

Idea: Display financial years by final year, not starting year

Common complaint amongst our users, when using a financial year that is not Jan to Dec, is that the slicer displays the year based on the year of the first month. Our users expect the year, when talking a financial year, to be the year of the final month.

I.e. April 2018 to March 2019 is considered FY2019 or FY18-19

Slicer too big

Hi, great slicer and I use it daily! I have a request , it takes up about 25% of the page , and I would like some control for the size.

It's great but its so big! I would also like a recommendation as to where I could change some of this to make a custom version myself.

Visual is not aplicable with custom theme

Hello

I want to add this visual to my custom theme and just change font size, font color, font of the labels and the height. Unfortionally it was not possible, not even to disable labels.

here my theme.json

"Timeline1447991079100": { "*": { "labels": [ { "show": false } ] } }

How is it possible to change anything in this visual using custom theme

Thank you

Regards, Ivayla

Hover-over text is incorrect in week selection mode

If you hover over a specific week on the timeline when in week selection mode, the text reads "Year 3 - 2022, Q1 Jan" when the correct text would be "Week 3 - 2022, Q1 Jan".

ISO 8601 week determination with adjustable beginning?

Although I recognize that ISO 8601 specifies Monday as the beginning of the week, I would like to be able to have the far superior year-end behavior of the ISO 8601 week determination method coupled with the ability to set the first-day-of-week to Sunday as our industry has historically adopted. This could be accomplished via either an additional setting within the ISO 8061 standard, or as a separate standard (perhaps "ISO 8601 Sun").

Cannot Build visual after downloading and running pbiviz command

Hi

Thank you for the great library. I am trying to use it after downloading and running it on my local server for Developer visual.

After running "pbiviz start" command, it is giving me below error.

 info   Building visual...
 error  VALIDATION   Invalid API Version v2.5.0

As per other Git hub thread, I tried to run npm i and npm start commands but seems it is no help.

I also tried thread https://github.com/Microsoft/PowerBI-visuals-tools/issues/242 to fix it but still, it is giving me enough errors in the console. Something like this:

 info   Starting server...
 info   Start preparing plugin template
 error  error:0906D06C:PEM routines:PEM_read_bio:no start line

Any smooth process, steps to fix this issue?

Thanks in advance.

Any resolution to the issue related to Timeline Slicer where it allows current period as default upon selection of property "Force Selection" but doesnt allow to reset the slicer when user trying to select other months.

Any resolution to the issue related to Timeline Slicer where it allows current period as default upon selection of property "Force Selection" but doesn't allow to reset the slicer when user trying to select other Periods.
what is the point of having default and not able to reset the default (interactivity) of the control .

Support for Hour and Minute granularity

It would be good to have the granularity increased with hours and minutes or fractions of minutes