Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have the following dataset :
In PBI :
Lines = Personne then a Project granularity (blacked fields)
Columns = none
Values = Each months + the two last columns in the matrix above
I have several persons (red fields), for each of them I have the number of days they worked on different projects they have been affected to (the blacked fields).
In last two rows, I have the number of days that they should have attended on a given month (named Nombre de jours attendu) and the sum of days on all the project they have been working on (named Total).
I would like to add a new row for each person, comparing the value of the "Total" row and the "Nombre de jours attendu" row.
Then, I'll implement a color rules, where negative fields will be red so I know when someone hasn't filled his sheet properly.
Thanks for the help !
Solved! Go to Solution.
Hi @Zoko,
Please check the demo in the attachment. Though there are many steps, it works.
All the steps are applied in the Query Editor.
Best Regards,
Dale
Hi @Zoko,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
Hi @Zoko,
As far as I know, I'm afraid we can't add a custom row in the rows of a Matrix. Can you share the original data? A dummy one is enough. Maybe we can find a workaround.
Best Regards,
Dale
Hi @v-jiascu-msft,
My data comes from a folder having 30 excel files of the different persons working in the company on various projects, one excel file looks like this :
Project name | Janvier | Février | Mars | Avril | Mai | Juin | Juillet | Août | Septembre | Octobre | Novembre | Décembre | Nb de jours depuis le début de l'année | Nb jours estimé sur l'année |
GreatProjectName1 | 9,5 | 16 | 16,5 | 11 | 8 | 14 | 75,00 | 153,00 | ||||||
GreatProjectName2 | 5 | 2 | 2 | 3 | 2,5 | 3 | 17,50 | 30,00 | ||||||
Congés ou autre absence | 7,5 | 2 | 3,5 | 5 | 7,5 | 4 | 29,50 | 0,00 | ||||||
Total | 14,5 | 18 | 18,5 | 14 | 10,5 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 92,5 | 183 |
Nombre de jours attendu | 22 | 20 | 22 | 19 | 18 | 21 | 22 | 22 | 20 | 23 | 20 | 18 | 247 |
Adding a custom row in Power BI would be equal to adding a new column to this table (and by extension to all the excel files).
However I can't change the template of these documents.
Hi @Zoko,
Please check the demo in the attachment. Though there are many steps, it works.
All the steps are applied in the Query Editor.
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |