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.
hi imy
Without knowing exactly what measure you are using. I would assume you could click on the measure in the field pane, then click the Modeling tab on the tool bar. Next select percentage under the format drop down list.
As far as the bar width goes, MFelix is right on the money.
Hope this helps!
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?
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:
