Forum Discussion
Request Help Optimizing Donut Chart
I hope this will do it
https://drive.google.com/file/d/1Yt2BYEM8mrM5IqVrC7PAFIN4TI64-Wk5/view?usp=sharing
Add two measures, one for selected value and another for others
Selected Activities = SUM(Table[Activities] Other Activities = CALCULATE(SUM(Table[Activities]), ALL(Table)) - [Selected Activities]
Drop donut chart and these two measures in the values.
Your mesaures are a very simple way to do what I have suggested (replacing teh activity with hours). Very efficient solution (for me).
It's almost like I need to dynamically define what the "Other Total" should be...?
CoreyP as mentioned earlier, can you share your data in excel using google drive or onedrive what ever works for you
Click Here for *.xlsx of my tables
Note: I removed the employee name field, as well as the hourly rate and labor cost fields because that information in confidential, and not needed in this example, i don't htink.
