Excel Tips
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.
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.
First Power BI Step: Get a Free Account for Power BI »
April 5, 2023
How do I get started with Power BI?
January Actuals and February Plan »
March 31, 2023
If you take your regular Excel data through Power Pivot, the data becomes an OLAP pivot table, and therefore you can use named sets.
Convert Power Pivot to Formulas »
March 30, 2023
I talked about all the bad side-effects of having Power Pivot use OLAP pivot tables. Here is one advantage that you can take advantage of because it is an OLAP table.