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.
Hello everybody!
I have this matrix visualization:
COMPANY | Hours | Invoiced |
B25 | 182,57 | 5.794,00 |
Area1 | 109,57 | 3.300,00 |
C | 2,25 | 0,00 |
D | 0,25 | 1.300,00 |
E | 80,07 | 0,00 |
F | 27,00 | 2.000,00 |
Area1 | 40,00 | 1.854,00 |
A | 23,00 | 1.500,00 |
C | 12,00 | 100,00 |
D | 5,00 | 254,00 |
Area2 | 33,00 | 640,00 |
A | 14,00 | 320,00 |
B | 10,00 | 120,00 |
C | 9,00 | 200,00 |
B30 | 118,00 | 97,00 |
Area1 | 59,00 | 24,00 |
B | 36,00 | 14,00 |
C | 23,00 | 10,00 |
Area2 | 59,00 | 73,00 |
A | 24,00 | 63,00 |
B | 35,00 | 10,00 |
Total | 300,57 | 5.891,00 |
The rows are the fields COMPANY, AREA, COLABORATOR and I want to filter the COLABORATOR row to don't show the A colaborator value in the table but I need his value totalizated in the Area rows, to show it like this:
COMPANY | Hours | Invoiced |
B25 | 182,57 | 5.794,00 |
Area1 | 109,57 | 3.300,00 |
C | 2,25 | 0,00 |
D | 0,25 | 1.300,00 |
E | 80,07 | 0,00 |
F | 27,00 | 2.000,00 |
Area1 | 40,00 | 1.854,00 |
C | 12,00 | 100,00 |
D | 5,00 | 254,00 |
Area2 | 33,00 | 640,00 |
B | 10,00 | 120,00 |
C | 9,00 | 200,00 |
B30 | 118,00 | 97,00 |
Area1 | 59,00 | 24,00 |
B | 36,00 | 14,00 |
C | 23,00 | 10,00 |
Area2 | 59,00 | 73,00 |
B | 35,00 | 10,00 |
Total | 300,57 | 5.891,00 |
How can I do it?
Thank you very much for your help.
Hi @Raul,
Currently, in Power BI when we filter a dataset, the result will also be affected. It also means once the colaborator A has been filtered, the Grand total value will also be affected.
Thereby I'm afraid your requirement cannot be achieved. And there already exists a feature request for it. You can vote it up.
Thanks,
Xi Jin.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |