Forum Discussion
Raul
Post Patron
Post PatronAdd a filtered row in the total
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.
1 Reply
v-xjiin-msftSolution Sage
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.