I have this matrix visualization:
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:
How can I do it?
Thank you very much for your help.
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.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!