Forum Discussion
Solved
Data Label on Graph
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!
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.
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.
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.
My measures:
My graph:
Any idea why they all say 100%?
You just need to add ALL() around 'individ Project2'
count of all = COUNTROWS(ALL('individ Project2'))
Thank you for your assistance!