Forum Discussion
Anonymous
6 years agoNot applicable
undefined
Good day power users. I receive daily contributions for our cooperative group of over 50 members. I want to be able to visualizes and see what each member has contributed over the year. see...
Fowmy
6 years agoSuper User
Anonymous
First, you need to remove the total row for each name in Power Query. then add a date column as each 1st day of the month instead of the month name and add month number to sort it.
Use a bar chart to show all 50 members by contribution amount and if you need to see across months, you can also use a matrix. You can add an additional measure as a % of the total as well
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂