Skip to main content
Microsoft Idea

Power BI

Merged

More formatting options for totals in a table (alignment, calculations, conditional formatting, etc.)

Vote (9) Share
David Daniele's profile image

David Daniele on 03 Aug 2018 18:12:49

Currently in the Table Visualization, users are only able to turn Totals on or off and only changing the font/color and outline. It would be very useful to have more options in here similar to the Matrix Visualization and more. Some I would love to have are:

- Alignment – Same as you have it for Field Formatting where each field gets its own option to choose how they want the total to display.

- Different types of total options – Right now I have to write a DAX query to get a different total calculation than the default ‘Sum’ that it does. This is not intuitive and I think more options here would make a huge difference. For instance, have the ability to choose Average, Percent to Total, Mode, etc.. Here is an example of what I need to do in order to achieve a custom percent to total of a column:

Total formatting different =
if(
HASONEVALUE(MyTableName[ColumnX]),
SUM(MyTableName[ColumnNeedsDifferentTotal]),
format(sum(MyTableName[ColumnNeedsDifferentTotal])/COUNT(MyTableName [ColumnNeedsDifferentTotal]),"Percent"))


- Ability to apply conditional formatting to totals