Forum Discussion
Percentages
Instead of relying on quick measures, build the measure you want. You have:
Tickets = COUNTROWS(WHD_Tickets)
Build one to show % Grand Total:
%Grand Total =
VAR AllWhdTickets = CALCULATE([Tickets], ALL(Table[Status]))
Return
DIVIDE([Tickets], AllWhdTickets)
Please keep in mind that I do not know what your table is named or the column for your descriptions, you will need to put the correct data into the variable.
I use this measure for many other visualizations, where I don't need them as a percentage.
On this particular chart, I need each bar to show the percentage of the total count.
Does this explain it better?
Imy
Ah, in that case, create your bar chart, then drag your measure to the value slot. Then click the little arrow on the side of the measure and select show value as... percent of grand total. It should break out each employee/building/part/whatever's percentage of the total tickets
That Simple! Thank you very much! Is there any way to make the bars wider and to format the % decimals?
No problem, for the decimals, go to the chart formatting menu, then click data labels>click the value decimal places and type "0".
For the bar width, try what MFelix suggested.
Hi,
I just realise my x-axis its also in percentages. Ideally, I would like to have them in numbers and the bars in percentages. Its this possible?
This is the end result
Off of the top my head, the quickest thing you could do is drag the % of grand total measure to the tool tip section, then drag the original measure from the fields pane to the value section. It will give you an outcome similar to this:
