Episode 154: July 2020 Power BI Desktop Update

This is episode 154 recorded on July 22nd, 2020 where John & Jason talk about the July 2020 Power BI Desktop Update including Gradient Legend, Azure Maps Visuals, and the fact that Power BI Desktop now supports external-tool extensibility, as well as the new Dataflex.

Show Notes

Microsoft Lists goes GA

Get the Power BI External Tools tab to show up

New platform for ideas.powerbi.com

Power BI Desktop July 2020 Feature Summary

Reporting

• Gradient legend
• Ability to further customize slicer header text
• Relative time filter is now generally available

Analytics

• Enhancements to Q&A
  • Field synonyms
  • Visual renames as suggested synonyms
  • Orange underlines for ambiguous terms
  • Updates to Q&A pop-out

Visualizations

• Azure Maps visual (preview)
  • Bubble layer
  • 3D bar chart layer
  • Reference layer
  • Custom tile layer
  • Real-time traffic overlay
• Updates to Multi-Axis Chart by xViz

Modeling

• Support for Excel financial functions
• Model view enabled for live connect is now generally available

Data Preparation

• Global option to disable automatic type detection

Template Apps

• YouTube Analytics by MAQ Software

Other

• Launch external tools from Power BI Desktop (preview)

Ideas Picks

John

Allow the Azure Maps visual to lookup text based geographic data

The new Azure maps visual is quite powerful, but it is currently lacking the ability to geocode a place name like the original map visual can. Adding this capability would mean that it could be used with data that has not already been geocoded.

Jason

Sparkline

Can we add sparkline support to tables and matrix? Native Excel PivotTable supports it.

http://www.tips-for-excel.comhttps://bifocalstorage.blob.core.windows.net/bifocalwebsitecontent/2011/07/Picture117.png