Power BI Tips and Tricks - Vol. 2

After the release of my two major Power BI works: Ski Resorts Finder and Global Cost of Living I decided to pick 12 interesting Power BI techniques I used, and I put together this interactive guide, where I explain how to implement them.

The list of topics includes:

Data Visualization & UX/UI

1. Create dynamic Shape Maps that allow to switch between regions and measures
2. HTML reader for custom visualizations
3. Build customized Canvas Backgrounds using Power Point
4. Level-up navigation buttons making them interactive
5. Grey App-Style Backgrounds for pop-up effects

Data Sourcing & Modelling

1. Import custom images from a local folder
2. Extract Live Currency Exchange Rates from an APIs connection
3. Override the Drill-Through's "Keep All Filters" option for a more flexible UX
4. Manipulate a web link (Booking.com) to obtain a dynamic link to assign to a button

Productivity & Automation

1. Schedule automated data refreshes: make it easy sourcing data from the cloud
2. Organize measures in folders to avoid mess in your data model
3. Using Tabular Editor to replicate and/or edit measures in bulk

If you need to reach me out with some questions, feel free to do so through Linkdln - link to my profile