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
Percentage of global is great when the chart display all values, when it is a "top N" the percentage of global is in fact the percentage of the "top N" So the percentage is wrong !
RE: Percent of total
Could do with percentage of column/row total being added as a display option to (non-100%) bar charts, it's something we need pretty badly and we're resorting to botching together a custom R visual in the interim period
RE: Percent of total
When will percent of row/column total be added? It is a common business question that is asked about many different dimension fields. Have to create separate calculations for each one is tedious and time consuming.
RE: Percent of total
It is a great feature! How can I change the decimals of the %, the default is 2 decimals, like 43.76%, how can I change it to 44%.
RE: Percent of total
Definitely need % of column/row
RE: Percent of total
It also would be great to have features (statistics % of row/columnl) as in matrix table for charts (bar, column, line, etc). Please, please, please :)
RE: Percent of total
If you have to show it on the dashboard, you don't need to calculate a new measure because the software can automatically do the sum for you. You just need to add the new measure %= IFERROR(SUM(hours)/SUM(employees]),0)
RE: Percent of total
i want to generate a % of how much hours per person did our employees get on trainging. I can calcute the quantity of employees and the total hours as a NEW MEASURE, but i want to divide this two numbers so i get the % of training by employee.
those any one know how to do this?
RE: Percent of total
HI guys, I was also stuck on that and I found a solution. Instead of adding a "New Column" to to show the percentage, you should add a "New measure"- then on the dashboard it will show as column1/column2 instead of an average/ median . . . :)
RE: Percent of total
Hi Kim,
Seems Quick Calc doesn't support SSAS Live Connection data source.
Do you have any time frame that this can be supported?
Thanks,