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 (this blog)
- Using financial functions from Excel in Power BI
- Gradient legends
- Customisable slicer headers
- Relative time filters
- 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.
Changes in the July 2020 update to Power BI Desktop
A quiet month, as befits the summer holiday season. Here are the main changes:
|DAX financial functions||Virtually all of Excel's financial functions are now available for use within Power BI.|
|Gradient legend||If you set conditional formatting for a bar, column or scatter chart, your legend can now reflect this.|
|Slicer header||You can now change your slicer header from the default.|
|Relative time filter||You can use a slicer to show (for example) events taking place in the last 3 hours, or in the next 20 minutes.|
|Q&A updates||There are a host of small updates to how you can use the Q&A visual.|
In addition to the above, there's also the new Azure map visual now in preview (following my usual policy, I'll blog on this when it isn't an option that you have to turn on to use).