Forum Discussion
Request Help Optimizing Donut Chart
I hope this will do it
https://drive.google.com/file/d/1Yt2BYEM8mrM5IqVrC7PAFIN4TI64-Wk5/view?usp=sharing
Did you tried the measures I posted here, I assume that will do it.
I tried what you said, but it doesn't work and I'm thinking I misunderstood what you said because what I'm doing doesn't seem logical.
Activity table:
Table Name: Activity
Column 1: Activity Number
Column 2: Activity
Labor table:
Table Name: Labor-ALL Activities
Column 1: Date
Column 2: Lastname, Firstname
Column 3: Activity
Column 4: Labor Hours
Column 5: Labor Cost
The measures I wrote:
Selected Activity = SUM(Activity[Activity]) (Which doesn't make sense to me, because you can't sum text)
Other Activities = CALCULATE(SUM(Activity[Activity]), ALL(Activity)) - [Selected Activity]
I probably did that all wrong, huh?
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?