topic Re: Data Labels on a Line Graph in DAX Commands and Tips

Data Labels on a Line Graph

e175429 — Thu, 24 Jul 2025 19:28:37 GMT

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.

Re: Data Labels on a Line Graph

HearnTexas — Thu, 24 Jul 2025 19:42:06 GMT

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
)

Re: Data Labels on a Line Graph

wardy912 — Thu, 24 Jul 2025 20:04:09 GMT

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!

Re: Data Labels on a Line Graph

e175429 — Fri, 25 Jul 2025 19:59:23 GMT

Thank you, this worked.