Forum Discussion
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 everything, except when I try to show percentages.
Also, is there a way to make these bard wider? Many thanks for your help!!
Here is what I have (counting rows):
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.
19 Replies
Hi my only measure in this
Tickets = COUNTROWS(WHD_Tickets)I would like to have the number of tickets and the % to the grand total.many thanks!
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!
Hi, sorry I should have mentioned this, my only value is the following measure:
Tickets = COUNTROWS(WHD_Tickets)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
Dear calebmfoster
Thank you for your answer but I do not have a % to grand total measure, how do I do this?
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.
Many thanks! It worked
Hello,
I'm also trying to plot percentages on a bar chart. I alredy have the perentage as a deceimal but I can't see anyway to plot them as percentages. Can anyone help?
