This page has 0 threads | Add post

Blogs

Many people around the world enjoy and benefit from our blogs. If you're one of them - and can afford to - please make a small donation to help keep this and future blogs, exercises, skills assessment tests, tips, tutorials and videos freely available to everyone!

Some other pages relevant to these blogs include:

You can also book hourly online consultancy for your time zone with one of our 7 expert trainers!

Changes in the July 2020 update to Power BI Desktop Part five of a six-part series of blogs
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

Changes in the July 2020 update to Power BI Desktop

Part five of a six-part series of blogs

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 15 November 2023

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

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!

Parts of this blog
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