Forum Discussion
Line Graph Aggregate instead of Average
Hi El_Bastien ,
Could you share the sample data and the expected outputs?
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Best Regards,
Wearsky
| Employee | Category | Month | Period | Count |
| 904 | GT | April | 01/04/24 | 1 |
| 54 | A | April | 01/04/24 | 1 |
| 363 | C | May | 01/05/24 | 1 |
| 1 | D | May | 01/05/24 | 1 |
| 54 | A | May | 01/05/24 | 1 |
| 591 | C | June | 01/06/24 | 1 |
| 1 | D | June | 01/06/24 | 1 |
| 54 | A | June | 01/06/24 | 1 |
| 489 | C | July | 01/07/24 | 1 |
| 1 | D | July | 01/07/24 | 1 |
| 54 | A | July | 01/07/24 | 1 |
| 591 | C | August | 01/08/24 | 1 |
| 1 | D | August | 01/08/24 | 1 |
| 54 | A | August | 01/08/24 | 1 |
| 591 | C | September | 01/09/24 | 1 |
| 1 | D | September | 01/09/24 | 1 |
| 244 | D | September | 01/09/24 | 1 |
| 54 | A | September | 01/09/24 | 1 |
| 1 | D | October | 01/10/24 | 1 |
| 54 | A | October | 01/10/24 | 1 |
Here is the sample data.
Ignore the "Employee" column as it is unimportant to the problem.
The expected outputs are:
Average Quarterly Headcount by Category. In my first message, I inserted a picture of what the line chart has to be like. The problem with that is that PBI aggregates each quarter, and I need the average. for example if: M1=100, M2=105, M3=110, the Q1avg = 105. The average must be shown when displaying the year and the quarter (as shown in the picture). If necessary, we can add the month as the lowest level, but that is optional.
Thank you so much! Anonymous