BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
This month introduces a smorgasbord of small but useful updates, including the ability to hide pages, colour data labels and to set the anchor (from) date for a relative date slicer.
- January 2018 updates for Power BI Desktop
- Features in preview for the January 2018 update
- Showing and hiding pages
- Changing the background colour of data labels
- Changing the areas of a chart assigned to labels and bars
- Anchor dates for relative date slicers (this blog)
For a cumulative list of all of the updates to Power BI Desktop since November 2016 see this blog, or have a look at the Power BI courses that we run.
Posted by Andy Brown on 11 January 2018
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Anchor dates for relative date slicers
So a quick refresher first. When you make a date field into a slicer, you can then display this as a relative date slicer:

Choose this option to get a relative date slicer.
You can then choose what you want to see:

Here we're showing data for the last or next two years, taken from the current date.
The clever thing that this update introduces is that you can now set an anchor date:

You can click on the symbol shown to choose the anchor date from a calendar.
The Include today setting works as follows. Suppose that you set the anchor date to be 1st January 2018, and show the last 1 week. Here's what you'll get if you set Include today to Off:

If you're not including today, you get the 7 days before "today".
If you set Include today to On, by contrast, you get the 7 days leading up to and including "today":

If you include today, the anchor date is included within the date range.
By default, the anchor date is included in a relative date slicer (Include today is set to On).
- January 2018 updates for Power BI Desktop
- Features in preview for the January 2018 update
- Showing and hiding pages
- Changing the background colour of data labels
- Changing the areas of a chart assigned to labels and bars
- Anchor dates for relative date slicers (this blog)