Skip to main content

Power BI

Completed

Percent of total

Vote (791) Share
Haydn Richardson's profile image

Haydn Richardson on 06 Dec 2014 03:56:36

In addition to sum, average, min, max etc. I'd like an option in values for % of total

Administrator on 01 Jun 2016 05:13:31

We shipped % of grand total as a part of quick calcs in the May release of Power BI desktop. Next up, % of column and % of row total. Give it a try and let us know what you think. For info on how to use it, check out the blog post covering our May feature releases: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-update-feature-summary/

Comments (78)
Haydn Richardson's profile image Profile Picture

Power BI User on 05 Jul 2020 22:26:19

RE: Percent of total

when is the % of column and % of row being iimplemented

Haydn Richardson's profile image Profile Picture

Sheeba Mathew on 05 Jul 2020 22:26:03

RE: Percent of total

hi guys, any indication on when the % of column and % of row totals will be implemented?

Haydn Richardson's profile image Profile Picture

Nicola Jelmorini on 05 Jul 2020 22:25:05

RE: Percent of total

I hope, like other people, that " Next up, % of column and % of row total" will be implemented as soon as possible. Thanks .

Haydn Richardson's profile image Profile Picture

Power BI User on 05 Jul 2020 22:24:05

RE: Percent of total

Hi Kim - % Of Grand Total is magic. Could you please indicate when % of Row/Column total will be released?

Haydn Richardson's profile image Profile Picture

Terence Oh on 05 Jul 2020 22:23:59

RE: Percent of total

Pikachu, I choose you.

Looking forward to the % row and column totals. This is most welcome indeed.

Haydn Richardson's profile image Profile Picture

Chandraveer on 05 Jul 2020 22:23:50

RE: Percent of total

Thanks for getting the % of total. I have one comment though, earlier upon hovering over the chart I was able to see both % as well as the data, now after enabling the % of total I cannot see actual data values even with hovering over the chart section, this seems to be loss of representation of data from previous version.

Haydn Richardson's profile image Profile Picture

angus jordan on 05 Jul 2020 22:23:33

RE: Percent of total

Do we know if the May release has fixed the bug with mdx queries fixed yet? We can't upgrade until this is fixed.

https://community.powerbi.com/t5/Desktop/MDX-script-not-being-recognised-in-new-version-of-power-bi/m-p/41608#M15781

Haydn Richardson's profile image Profile Picture

Anonymous on 05 Jul 2020 22:23:32

RE: Percent of total

I'd like to be able to display % along with the category. Currently, we can only display category and/or data value but not the new % calculation? Correct or am I missing something? Thanks!

Haydn Richardson's profile image Profile Picture

Power BI User on 05 Jul 2020 22:22:36

RE: Percent of total

Please add formatting options to this new feature, e.g. selecting number of decimal places

Haydn Richardson's profile image Profile Picture

Power BI User on 05 Jul 2020 22:22:34

RE: Percent of total

yes please the same options as in excel pivotting. % of rowtotal, % of columntotal etc