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)
RE: Percent of total
There is a blog here http://www.cognim.co.uk/power-bi-quick-tip-percent-of-total/ that shows one way to do it.
RE: Percent of total
This is a no brainer!!!
RE: Percent of total
This is a must have!
RE: Percent of total
Please please please
RE: Percent of total
% of total is definitely needed
RE: Percent of total
ThinkCell features are nice to have
RE: Percent of total
'+1 please! Plus may I suggest all the functionalities of the ThinkCell ppt add-on? :)
RE: Percent of total
The suggested "ALL" fix will not work if there are slicers that limit your table display selected by the User. The % of Total needs to be out of a dynamic table that keeps changing based on user inputs and the percentages continue to readjust as the total changes. ALL ignores all filters and ALLEXCEPTS are limited.
RE: Percent of total
When this will be released?
RE: Percent of total
I was also getting really frustrated with this, but the solution is a very simple principle.
by creating a column named "percent" which is the following calculation: Percent = 1/COUNTROWS(Table1) and format it as %, you automatically can drag it as a value to any kind of chart/graph and will display accurate % value.