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 perform a custom sort... I dont need Power BI make the sort un logical numbers... i need to sort the chart in diferrent ways
RE: Percent of total
how can I display percentage and not whole numbers ? in a chart with measures I created
RE: Percent of total
Hello Kim, is there a way you can format the totals? E.g. by default, if you enable the totals, it just sums the values in each column.
Now, let's say I have 3 columns.
Total column 1 = SUM of values in column 1 (that's ok, Power BI does it already).
Total column 2 = SUM of values in column 2 (that's ok, Power BI does it already).
"Total" column 3 = Total column 2 / Total column 1.
Is there any way to do this with Power BI please?
Thanks in advance for your kind cooperation.
RE: Percent of total
I was also looking to get the data display in percentage and couldn't find the option, Please let us know when it will be available
Cheers
RE: Percent of total
Great news! When it goes in, will there be the option to turn on / off % and actual value so I can share sensitive information in % without having the numbers next to it too?
RE: Percent of total
Great News on the addition! can't wait!
RE: Percent of total
Agree!!
RE: Percent of total
Voted!
Please also allow the opportunity to create report-scope DAX measures!
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13676700-report-scope-dax-measures-and-tablix-based-repor
RE: Percent of total
Very important thing!, nice idea. This is a common feature already in, for example, donut chart in Excel, where positioning the mouse over the each graph part you can read the percentage of the total.
I would suggest to include a total on the visuals data table you can deploy when you maximize the visual to full screen. Right now only a table with amount is shown, having the option to show subtotals and/or totals as PivotTables would be really helpful.
RE: Percent of total
I vote in favor too!