COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
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.

  1. Changes in the July 2020 update to Power BI Desktop
  2. Using financial functions from Excel in Power BI
  3. Gradient legends
  4. Customisable slicer headers
  5. Relative time filters (this blog)
  6. Q + A updates

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

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).

Relative time option

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:

Last, Next or This Minutes or hours
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! 

This blog has 0 threads Add post