BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
This month's modest update allows you to use Excel financial functions in DAX, show a gradient legend and change your slicer header, among other minor changes.
- Changes in the July 2020 update to Power BI Desktop
- Using financial functions from Excel in Power BI
- Gradient legends
- Customisable slicer headers
- Relative time filters (this blog)
- Q + A updates
Posted by Andy Brown on 23 July 2020
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 time filters
This is a very niche feature - you'll either find it useful (if you use times) or useless (otherwise).
For any slicer based on a date/time field, you can now choose to select by the relative time when things occurred.
This works exactly like the Relative Date option for dates:
|Choose to go back or forward ...||... a given number of minutes or hours.|
If you don't work to the level of detail of hours and minutes, you can safely ignore this new feature!