Forum Discussion
Request Help Optimizing Donut Chart
I hope this will do it
https://drive.google.com/file/d/1Yt2BYEM8mrM5IqVrC7PAFIN4TI64-Wk5/view?usp=sharing
no you are right, what you trying to show in donut chart?
Total Activities or Total Hours?
Didn't read your thread in detail but I just posted the solution but what you are trying to do is not something which cannot be done.
Total hours.
So,
Total Hours = SUM(Labor-ALL Activities[Labor Hours])
Then, when the slicer filters per activity, it would become:
Total Hours of "Selected Activity" = CALCULATE([Total Hours], Activity[Activity] = "Selected Activity")
...where "Selected Activity" is Data Entry, or Dimming, or whatever.
I want my donut chart to show:
Total Hours of Selected Activity vs. Total Hours
For instance, if the total hours equals 73,660, and Data Entry is 22,740, the donut chart would show Data Entry as 31% of Total Labor.
Does this make sense, or are you saying that this cannot be done?