undefined

[Anonymous]

 

 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 picture below. Is just an excerpt for two months and 5 members. What measure can I use to have this table? thank you

[Greg_Deckler]

@Anonymous , @Fowmy  has some good thoughts but I can't really tell exactly what you want. I see that you are a New Member so, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Fowmy]

@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 🙂

YouTube, LinkedIn