Excel Tips


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.


Add Lines using Analytics »

May 8, 2023

Use the Analytics icon to draw dynamic lines on your chart. You can add a line to show the average or at 80% percentile or a line at a constant value.


Formatting a Chart »

May 5, 2023

Power BI Desktop offers a lot of formatting choices. The second icon at the top of the drop zones allows you to format the chart. Although Legend appears with a single control for On or Off, if you click the V to the left of the word Legend, the choices will expand to offer many other settings.