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.
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'))