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
I vote positive on this topic
RE: Percent of total
1) There should be at least as many options as in pivot tables in excel (i.e., % of row total, % of parent row totel etc.)
2) it should be possible to refer to the results of those %s directly in other measures (because achieving those same alternatives of %s, exclusively through measures is not practical).
RE: Percent of total
Found this solution to work for me: =SUM(ResellerSales_USD[SalesAmount_USD])/ CALCULATE(SUM(ResellerSales_USD[SalesAmount_USD]), ALLSELECTED () )
source: https://msdn.microsoft.com/en-us/library/gg492186.aspx
RE: Percent of total
VERY much needed, and frankly shocked it wasn't there to begin with!
RE: Percent of total
Please! It's very much needed to display number as percentage... e.g. 85.3% instead of 0.853....
RE: Percent of total
'Hello everyone,
I have found a way around % issue. Please review the following steps:
1- Make sure that the column is calculated to show number. For instance 6% the column contains 6.
2- change the whole column to Text format
3- Add new column that concatenate 6 & %. Further it will be as follow:
=[#"Education Spending"] & "%"
------------
Since this a reporting column and will not be used for calculations, it is ok to be a text.
I hope this helps.
Hameed
RE: Percent of total
Yes, totally agree. You have my three votes.
In excel, when Donut Graph is used and mouse is over, you can read not only the value itself (sum,average etc) but also the percetage from the total. Is this possible too in PowerBi?
RE: Percent of total
Is this solved?
Because I just created a graphic and I only can see the total number, but I don't finde the option to show the % value of the total. Thanks
RE: Percent of total
I would assume that being able to present data in absolute or % would be a basic function and have been key in excel pivot tables for decades
RE: Percent of total
I need percentage of totals field too.