The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
How do I get my data labels to show % instead of whole numbers?
This is my graph currently:
As you see, when I hover over a data point, it shows whole numbers.
I took these steps to try to get it to show %'s:
This is the result:
As you see, the %'s are sooooo wrong.
From the 1st image, in Jan-24, you see I have a total of 980.
930/980 = 95%
50/980 = 5%
These are the 2 %'s that sould be shown.
Solved! Go to Solution.
Hi @e175429
When you select 'Show value as percent of grand total', it's giving a percentage of all the data, so your percentages are correct, as it's showing Jan requests closed is 4% of all requests closed in all months.
You need to add a measures that compare the values against eachother, then change the format to percentage and add as tooltips. Change the below measures to fit your data:
Sales Amount by Due Date % =
DIVIDE([Sales Amount by Due Date], [Sum of Sales Amount] + [Sales Amount by Due Date], 0)
Sales Amount % =
DIVIDE([Sum of Sales Amount], [Sum of Sales Amount] + [Sales Amount by Due Date], 0)
You'll then have the following result (I'll leave the GT% in as an example)
I hope this helps, please give a thumbs up and mark as solved if it does, thanks!
Hi @e175429
When you select 'Show value as percent of grand total', it's giving a percentage of all the data, so your percentages are correct, as it's showing Jan requests closed is 4% of all requests closed in all months.
You need to add a measures that compare the values against eachother, then change the format to percentage and add as tooltips. Change the below measures to fit your data:
Sales Amount by Due Date % =
DIVIDE([Sales Amount by Due Date], [Sum of Sales Amount] + [Sales Amount by Due Date], 0)
Sales Amount % =
DIVIDE([Sum of Sales Amount], [Sum of Sales Amount] + [Sales Amount by Due Date], 0)
You'll then have the following result (I'll leave the GT% in as an example)
I hope this helps, please give a thumbs up and mark as solved if it does, thanks!
Thank you, this worked.
You will need to create a DAX measure to calculate that percentage. It's best to use the Divide function.
For example
PercentageOfLastYearSales =
DIVIDE(
[CurrentYearSales],
[PreviousYearSales],
0
)