Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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):
Solved! Go to Solution.
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.
Proud to be a Super User!
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?
HI @202001AB ,
Choose the measure or column and format it as % on menu bar.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsDear calebmfoster
Thank you for your answer but I do not have a % to grand total measure, how do I do this?
Remember the other reply I made and told you to drag your measure into values and hit the drop down menu? Do that but drag it to tool tip instead
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.
Proud to be a Super User!
Many thanks! It worked
No problem, be sure to select a comment as a solution so the thread gets closed.
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
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?
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:
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 @imy ,
You can format the decimals on the options of the chart - values format and define the number of decimals you want to have.
Rgards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi, sorry I should have mentioned this, my only value is the following measure:
Hi @imy ,
What is the percentage you want to make? can you share how your measure is calculated?
Regarding the size of the bar if you go to the Y-axis options you can play around with the inner padding and the category width.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi my only measure in this
drag that measure to both the value slot and the tooltip slot. Select the drop down arrow on the side of the measure in the tool tip slot and click show value as>% grand total.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |