This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Updates to Power BI Desktop for September 2022 Part three of a four-part series of blogs
You can now format reports differently for mobile view and display X axis labe`s hierarchically by default. One other tiny change is that default column titles in tables now include the summarisation method used. Updates to Power BI Desktop for September 2022 You can now format mobile report view differently Table column headers show the aggregation used by default (this blog) Hierarchical charts are turned on by default We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Updates to Power BI Desktop for September 2022

Part three of a four-part series of blogs

You can now format reports differently for mobile view and display X axis labe`s hierarchically by default. One other tiny change is that default column titles in tables now include the summarisation method used.

Updates to Power BI Desktop for September 2022
You can now format mobile report view differently
Table column headers show the aggregation used by default (this blog)
Hierarchical charts are turned on by default

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Posted by Andy Brown on 28 September 2022

Table column headers show the aggregation used by default

This is a very small change, but one which impact all Power BI report designers. If you add a numerical field to a table:

I'm about to show the quantity of purchases for each region in a table.

You now get this:

The heading for the column says Sum of quantity, showing which aggregation has been used.

Microsoft introduced this change following feedback from users: apparently people were getting confused as to which aggregation function had been used for a column, so Power BI will now always shown this by default (although obviously you can subsequently rename the column).

Enabling this feature for existing reports

If you want to apply this feature to existing reports that you've created, you can:

The setting to change in File > Options and settings > Options.

Parts of this blog
Updates to Power BI Desktop for September 2022 You can now format mobile report view differently Table column headers show the aggregation used by default (this blog) Hierarchical charts are turned on by default