MS Power BI Hacks: The Ultimate Guide

MS Power BI Hacks: The Ultimate Guide

2021-01-27T14:46:07+00:00By |Power BI|

Power BI. It’s … well powerful. And there’s a ton of power hidden under the hood that you should know. These aren’t fun hacks. They are serious workflow improvements you can take advantage of right now. Don’t have Power BI? Get the latest version here.

If you’re not even proficient at BI, may we first recommend some videos?

  1. From EdurekaPower BI Full Course – Learn Power BI in 4 Hours
  2. From Naresh i TechnologiesPowerBI Online Training Session 1
  3. From Zebra BI7 Worst Power BI Dashboard Mistakes & How to Avoid Them
  4. From Guys in a Cube: 5 things you didn’t know about Power BI Desktop
  5. From softlandingAll You Need to Know About Microsoft Power BI
  6. From Red Level GroupWhat’s The “Power” in Microsoft’s Power BI 

Making a Well-Designed Report

You need a report, but the default report looks about as exciting as a screenshot of a pivot table. How about some hacks for making those reports into something you’ll be proud to present to your team.

  1. From BI Elite: 7 Tips & Tricks for Stunning Power BI Reports
  2. From MicrosoftCreate reports and dashboards in Power BI – documentation
  3. From Microsoft Power BIBest practices in visualization creation in Power BI Desktop
  4. From Predica5 Power BI Tips To Make Your Reports More Appealing And User-friendly
  5. From: Search Engine LandBridging Data and Action: How to create killer reports
  6. From chassMSFTHow to Design Visually Stunning Power BI Reports

Visualizing Bing Maps with Power BI

You can do some killer things with Bing Maps and Power BI. Here’s a collection of links to some of the things you can do:

  1. From MicrosoftTips and tricks for Power BI map visualizations
  2. From SQLDustyPower BI and the Bing Maps API
  3. From SQLShackHow to create geographic maps using Power BI
  4. From OnlizerConnect Bing Maps + MS Power BI
  5. From YouTubeA whole list of Power BI + Maps videos

Building Killer Dashboards

Just like reports, having an impressive dashboard can save a meeting. Take a look at these tips and own your data. Or at least, make it exciting to look at.

  1. From Hitachi Solutions BraintrustPower BI UX Design Tips
  2. From Microsoft: Optimize a dashboard for mobile phones – Power BI
  3. From the Power BI TeamKiller Visualizations in Power BI
  4. From BI EliteBuilding a Power BI Dashboard/Report from Scratch (Beginner & Advanced)
  5. From DataFlairIncredibly Easy Method to Create Power BI Dashboard

Adding Icons to Power BI

You can add icons to Power BI. This is extremely helpful for making nicer reports, tables, and let’s face it, getting people to look at and interact with your creation. Even better, many folks making additional icon sets for Power BI. We’ll get to those in a minute, but first, let’s make sure you have icons enabled.

How to enable icons in Power BI

  1. Go to the Conditional Formatting menu
  2. Scroll down to Icons and flip the toggle to ON
  3. Below Icons is “Advanced Controls” and you want to explore in here because it is in here that you can customize the icons your way.

Icon Sets for Power BI

  1. From PowerBI.Tips (Custom icons and theme)
  2. From FlatIcon (Over 500,000 icons!)
  3. From DataVeld (more tricks with icons)

Bonus: 

Reddit has a thriving Power BI subreddit. It has over 36,000 members as of this writing and is frequently updated. LINK[https://www.reddit.com/r/PowerBI/].

If you or your team needs help learning Power BI, we offer some amazing QuickStart sessions for Power BI.

About the Author:

Red Level
As a comprehensive technology services company, Red Level delivers customized scalable technology solutions designed precisely to our client's unique needs – solutions that accelerate growth, reduce costs and enable collaboration. As a preferred partner to technology leaders such as Microsoft, DellEMC, and VMWare, we deploy the most advanced business technology solutions, ensuring optimal reliability, productivity and value.