Excel Tips


Load Your Excel Data to Power BI Desktop »

April 24, 2023

From Power BI Desktop, use Home, Get Data, Excel. Browse to your Excel file. A dialog will show a list of available tables, named ranges, and worksheets.


In Power BI Desktop, the Power Query Tools Are Called Get Data »

April 21, 2023

Open Power BI Desktop. There are three main modes available as icons along the left edge of the screen.


Add a Calendar Table »

April 19, 2023

As your Power BI skills advance, you may start writing DAX formulas that rely on time intelligence. These functions work better when you have a calendar table in the data model.


Prepare Your Excel Data for Power BI »

April 17, 2023

Power BI can import Excel files, but the data should either be stored in a named range or as a Table.


Enable Drill-Down Mode »

April 12, 2023

The Power BI team must love using tiny subtle icons, because Power BI is full of them. In the top right of a chart, this icon turns on Drill-down mode.


Click in one Chart to Filter Other Charts »

April 10, 2023

When you are viewing a report, clicking a column in one chart will cause all of the other charts to be filtered to that item.


Use Q&A to Investigate Your Data »

April 7, 2023

I don’t know what to look for in the sample data.


First Power BI Step: Get a Free Account for Power BI »

April 5, 2023

How do I get started with Power BI?