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

ad8bd68d b2dd-4609-96af-ef46df99a0b7 on 05 Jul 2020 22:35:54

RE: Percent of total

How to use it with OLAP source?

Haydn Richardson's profile image Profile Picture

4ef379c6 c03e-443c-8150-e73bd00593ab on 05 Jul 2020 22:34:53

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.

Haydn Richardson's profile image Profile Picture

6600e16d ea15-4689-b54a-f0e2283745fb on 05 Jul 2020 22:34:47

RE: Percent of total

Looks like I am just finding flaws in this program today, something this simple still not resolved?

Haydn Richardson's profile image Profile Picture

93816e08 7b94-4ed2-9f2a-aea8ebfe045a on 05 Jul 2020 22:33:09

RE: Percent of total

Hi! Any news about the % of column/ row feature?

Haydn Richardson's profile image Profile Picture

f196a325 0a1e-4911-a275-7abec56925cc on 05 Jul 2020 22:31:58

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%.

Haydn Richardson's profile image Profile Picture

8f7b58ab a66b-48ae-b49d-19bf954c53c6 on 05 Jul 2020 22:30:47

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?!

Haydn Richardson's profile image Profile Picture

ec557912 481a-e911-a95b-000d3a4f36ce on 05 Jul 2020 22:29:32

RE: Percent of total

Hi! Is there any prediction as when you'll have the % by column implemented in Power BI?
Thanks

Haydn Richardson's profile image Profile Picture

2e04e54a 8d50-40da-a47b-9e6071754172 on 05 Jul 2020 22:29:04

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?

Haydn Richardson's profile image Profile Picture

b350f939 6821-4c81-8dc8-1766a91569ed on 05 Jul 2020 22:28:48

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.

Haydn Richardson's profile image Profile Picture

bfd6f33a 4b5f-4e14-8155-b2f856cf7852 on 05 Jul 2020 22:28:06

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.