Excel Tips


Tricks for Navigating the Map in 3D Map »

June 1, 2023

You can easily fly through the map to focus on any part of the map.


Put a Pivot Table on a Map In Excel Using 3D Map »

May 31, 2023

Power Map is a new feature in Excel 2013. It was renamed to 3D Map in Excel 2016. If your data includes fields such as Street Address, City, State, Zip, Country, Continent, Latitude or Longitude, you can plot your pivot table on a map.


Share a Dashboard With Your Manager »

May 29, 2023

Anyone with the sharing link can access our dashboard? Isn't that dangerous?


Q&A Works on Dashboards, Not Reports »

May 26, 2023

To be able to use the Q&A feature, you have to promote your report to dashboard. From the report, select Pin Live View. Specify that you want to create a new dashboard.


Use Quick Insights »

May 23, 2023

The File menu in Power BI Desktop does not have the word File on it. Open the dropdown where the File menu should be and save your work as a PBIX file.


Add Titles, Logos, & Embelishments »

May 19, 2023

Use the Text Box, Image, and Shape tools to add titles and logos to your report.


Where is the Top 10 Filter? »

May 18, 2023

All of the Power BI Desktop features are shiny, new, and cool. Why can't I find the Top 10 filter so I show only the Top 5 customers in the bubble chart?


Using Maps in Power BI Desktop »

May 16, 2023

Two maps are built-in to Power BI Desktop. There is a regular map and a filled map.


Open Source Visualizations »

May 11, 2023

You've been stuck with the same 73 chart types in Excel for two decades. You won't have that problem in Power BI. The product is open source - developers can invent and design new visualizations.