In this module you will learn how to use the Timeline Power BI Custom Visual. The Timeline is a great tool for filtering date values on a report.
Module 26 – Timeline
- Power BI Custom Visual – Timeline
- Dataset – Gold Prices.xlsx
- Completed Example – Module 26 – Timeline.pbix
- The Timeline is similar to the native slicer in Power BI but has several more customizations available.
- Not surprising, this visual can only accept date values.
- If you need to adjust the start date of the Timeline based on your works Fiscal Calendar that is possible in the format settings.
This Timeline provides a filter for gold prices at the month level.
- Under the Format paintbrush there several options available for customizing the Timeline.
- Under the Fiscal Year Start section you will find the ability to adjust what is considered the first day of the year by setting the Month and Day properties to the beginning of your Fiscal Calendar.
- Next, you will find the First Day of the Week section which allows you to modify which day of the week is considered the first day.
- Making changes to the Range Header section will modify how the user see which date range is selected.
This shows what happens on the Timeline when the setting are modify as they appear above.
- Changing the properties in the Cell section will change the appearance of the Timeline cells that are selected or unselected.
- Changing the Granularity section will adjust slider that appears in the top left corner of the visual. Here you can modify the color and the level that is currently displayed.
Using the settings above will result in the Granularity Slider appearing like this.
- Under the Labels section you can adjust the appearance of any labels on the Timeline. This includes the label color and text size.
- In addition to these properties you have a set of settings that appears on every visual to adjust the background color, add a border around the visual and lock the aspect ratio.
Find Out More
You will always be able to find this video module and advanced viewing of future modules on the Pragmatic Works On Demand Training platform. Click here to learn more about this training platform that includes 25+ courses.
Catch up on all the Power BI Custom Visuals blog posts here.