BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
This is a bigger update than usual, with the highlight undoubtedly being the official roll-out of the much-trailed new table and matrix visuals.
- Updates to Power BI Desktop - July 2017
- New table and matrix visuals
- Renaming fields - at last!
- Incorporating custom visuals within Power BI Desktop
- Relative date slicers and filters (this blog)
- Responsive visuals which adapt to your screen size
- Breakdown option in waterfall charts
Posted by Andy Brown on 13 July 2017
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.
Relative date slicers and filters
You can now use relative date filtering in slicers and filters.
Relative dates in filters
Suppose that you want to show all of the sales made in the last 3 years. You could start by applying relative date filtering to a date field:
Choose this option when applying a filter to enable relative date filtering.
You can then choose from these options:
You can show values which are in the last, next or current day, month or year.
Here's how to show items in the last 3 years, as an example, including today's figures:
You can type in the number of time periods to go forward or back.
Relative date filtering in slicers
The first thing to note is that to use relative date filtering in a slicer, you can't turn the slicer header off:
I normally turn this off and use a slicer title instead, but you can't do this if you want to use relative date filtering.
When viewing a slicer, you can click on this downward arrow:
You can click on this arrow in the slicer header to choose a different way to filter the data.
Choose the obvious option to use relative filtering:
Choose this option to use relative date filtering.
You can then choose the exact filter you want to apply:
Here we're showing data for the last 3 years, but lots of other combinations are possible!
Relative date filters in slicers were introduced as a preview feature in May 2017 - I'm not quite sure when they slipped into live mode.