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

    bcacc6c4 50b4-4bd4-83fd-e26f8d0d1d20 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

    40ed8cb3 466f-4f70-ae22-58d930f3ce46 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

    b350f939 6821-4c81-8dc8-1766a91569ed 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

    93f660a2 65a4-4784-8653-0b5c03f95272 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

    74043208 c2db-4f73-9d83-bf8a037439fc 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

    4ee30ce0 c12e-4b6f-ad4d-236b4e2ebeaa 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

    0140ac9c 582e-4ad6-8317-985da26cd436 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

    94698ce1 d9f8-4710-a456-6232c5612e8d 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

    627de9b6 7c4f-45d2-9544-33e9e86327bb 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

    6d8addd2 2166-4289-b729-dd4a8be8e954 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