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
How to use it with OLAP source?
RE: Percent of total
This is only partially completed. It will not work for OLAP cubes, which is unfortunate, because Excel can do it easily.
The absence of this feature for people working against OLAP cubes forces the calculations back into the cubes, bloating the cubes, and making it so that users feel they have to go back to Excel.
RE: Percent of total
Looks like I am just finding flaws in this program today, something this simple still not resolved?
RE: Percent of total
Hi! Any news about the % of column/ row feature?
RE: Percent of total
if you want only a percentage of two columns like :
Total column 1 = SUM of values in column 1
Total column 2 = SUM of values in column 2
"Total" column 3 = Total column 2 / Total column 1.
add a measure and do the calculation as col2/col1 and format as % in Modeling pane to get values as 56% or 78%.
RE: Percent of total
How is it possible that this was not incorporated upon original release of the software, let alone still not released now?!
RE: Percent of total
Hi! Is there any prediction as when you'll have the % by column implemented in Power BI?
Thanks
RE: Percent of total
I ditto all the previous comments. This is a must have when transitioning from PowerPivot/Excel and really should be standard 'quick calc' options? Ref Kim's comments, what does "next up" mean?
RE: Percent of total
There is this other idea
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15052080-the-expand-the-quick-calc-funality
that asks the same thing, but it's not yet marked as Completed.
RE: Percent of total
When is the % of column and % of row being implemented in Power BI Desktop ? We need it very badly. Is there any alternative to create it in the report.