Forum Discussion
imy
7 years agoHelper I
Percentages
Hello, I wonder if you can help me: I am trying to create a bar chart with percentages. The only value in my data is a New Measure I created that counts the rows on the table. This works well for e...
- 7 years ago
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.
imy
7 years agoHelper I
That Simple! Thank you very much! Is there any way to make the bars wider and to format the % decimals?
Anonymous
7 years agoNot applicable
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.