cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Raul Member
Member

Add a filtered row in the total

Hello everybody!

I have this matrix visualization:

 

COMPANYHoursInvoiced
B25182,575.794,00
   Area1109,573.300,00
      C2,250,00
      D0,251.300,00
      E80,070,00
      F27,002.000,00
   Area140,001.854,00
      A23,001.500,00
      C12,00100,00
      D5,00254,00
   Area233,00640,00
      A14,00320,00
      B10,00120,00
      C9,00200,00
B30118,0097,00
   Area159,0024,00
      B36,0014,00
      C23,0010,00
   Area259,0073,00
      A24,0063,00
      B35,0010,00
Total300,575.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:

 

COMPANYHoursInvoiced
B25182,575.794,00
   Area1109,573.300,00
      C2,250,00
      D0,251.300,00
      E80,070,00
      F27,002.000,00
   Area140,001.854,00
      C12,00100,00
      D5,00254,00
   Area233,00640,00
      B10,00120,00
      C9,00200,00
B30118,0097,00
   Area159,0024,00
      B36,0014,00
      C23,0010,00
   Area259,0073,00
      B35,0010,00
Total300,57

5.891,00

 

How can I do it?

Thank you very much for your help.

1 REPLY 1
v-xjiin-msft Super Contributor
Super Contributor

Re: Add a filtered row in the total

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.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,768)