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.
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.
