Power BI has hundreds of great features, but I would argue that there is a Power BI feature that stands above the rest. And that is these three little boxes:
That’s right. Not the natural language query, VertiPaq engine, or content packs. But just that simple little left-hand navigation pane. And the reason is that it elegantly separates these three things:
Seems pretty basic, but maintaining this separation in Excel can become quite messy. Take this, for example:
Here you’ll notice both data and a visualization on the same page. Now watch what happens when you expand one of the rows in the table:
It adversely affects the chart, causing it to expand. Fortunately, Power BI maintains a clean separation of data:
Sometimes, however, you need to see both data and visuals in the same pane. Power BI feature allows you to resize visualizations without having any impact on the surrounding items:
This very basic architecture of Power BI Desktop makes it extraordinarily easy to design well-organized reports.