When using Power BI Desktop, it’s easy to miss some powerful features hidden in plain sight. If you’ve ever struggled with formatting custom visuals, mapping unusual locations, or organizing queries, this post is for you. Here are 5 Power BI Desktop tips that can make your workflow more efficient and your reports more polished inspired by a week of training in Lesotho, Malawi, and Mozambique.
Use the Selection Pane for Custom KPI Cards
If you build custom KPI cards by overlaying text boxes, shapes, and charts, you’ve probably run into the frustration of trying to select the right element on the canvas.
Open the Selection Pane under the View tab.
This lets you quickly highlight, rename, and toggle visibility for individual components of your card. It’s especially useful when designing layered visuals or when creating bookmarks.
Make Matrix Visuals Look Like Pivot Tables
Users often ask: “Why doesn’t the Power BI matrix look like an Excel pivot table?”
Select your matrix visual, open the Format panel, expand Row Headers, and turn Stepped Layout off.
This flattens the hierarchy, showing fields in separate columns just like a classic pivot table. You can also adjust indentation for more clarity.
Fix Mapping Issues with the Right Data Category
When mapping data, Power BI Desktop relies on Bing Maps to interpret your fields. If your towns or villages aren’t showing up:
Change the field’s Data Category.
For example, if your “town” field doesn’t map when categorized as City, try setting it to Place instead. You can test your location names directly in Bing Maps to confirm what works best.
Edit Data Entered Through “Enter Data”
If you use the Enter Data feature to create a quick table but later realize you need to update it, don’t delete and recreate.
Open Power Query Editor, find your table, and click the gear icon next to the Source step in Applied Steps.
This brings up the original entry dialog, where you can modify your data easily without touching the Advanced Editor.
Organize Queries into Groups
As your report grows, your list of queries can quickly become overwhelming.
Right-click on queries and use Move to Group to create folders like Parameters, Functions, or SQL Server.
You can multi-select queries using Ctrl, then group them all at once. This keeps your query editor clean and organized, making maintenance much easier.
Final Thoughts
Did you know all of these Power BI Desktop tips? If you’ve got your own favorite hidden features or questions about these techniques, drop a comment below — we’d love to hear from you!
And if you want to deepen your Power BI skills even further, check out this excellent Power BI training program.
