topic Re: Data Label on Graph in DAX Commands and Tips

Data Label on Graph

e175429 — Thu, 16 Oct 2025 17:15:03 GMT

Hey all,

I am able to get my graph to show EITHER whole numbers OR %. Is there a way to get both shown on the same graph?

Thank you!

Re: Data Label on Graph

djurecic — Thu, 16 Oct 2025 17:36:41 GMT

Please see the attached .pbix file. You can do this by creating an additional measure and putting it in the Detail section of Data Labels on your visual. Please let me know if you have any questions about this approach.

Re: Data Label on Graph

MasonMA — Thu, 16 Oct 2025 17:42:54 GMT

Hi, you may use this DAX sample from my report.

Request Count & % of Total = VAR CurrentCount = COUNT('table'[Request ID]) VAR TotalCount = CALCULATE( COUNT('table'[Request ID]), ALLSELECTED() --Adjust your filter modifier accordingly ) VAR Percentage = DIVIDE(CurrentCount, TotalCount, 0) RETURN CurrentCount & " (" & FORMAT(Percentage, "0.0%") & ")"

and add it in

Re: Data Label on Graph

e175429 — Thu, 16 Oct 2025 17:52:04 GMT

So, i don't have a number column like your sales column, I just have a column of user names like this:

And to create the graph I just put the user name colum on the x and y axis to see how many each user did:

So I can't sum a column of names.

Re: Data Label on Graph

djurecic — Thu, 16 Oct 2025 18:41:53 GMT

Ok, that's fine. You will need to create some measures- similar to the following- use whatever your actual table and field names are.

Count of Name = COUNT(Names[Name])

Count of All Names = COUNTROWS(ALL(Names))

Percent of Total Names = DIVIDE([Count of Name],[Count of All Names],0)

Then put Percent of Total Names into Data under Detail on the Data Labels section of the visual settings.

I've updated the .pbix file.

Re: Data Label on Graph

e175429 — Thu, 16 Oct 2025 19:03:54 GMT

My measures:

My graph:

Any idea why they all say 100%?

Re: Data Label on Graph

djurecic — Thu, 16 Oct 2025 19:16:16 GMT

You just need to add ALL() around 'individ Project2'

count of all = COUNTROWS(ALL('individ Project2'))

https://learn.microsoft.com/en-us/dax/all-function-dax

Re: Data Label on Graph

e175429 — Thu, 16 Oct 2025 19:49:59 GMT

Thank you for your assistance!

Re: Data Label on Graph

djurecic — Thu, 16 Oct 2025 22:06:53 GMT

You're welcome! Please "Accept as solution" if it has solved the issue.