How to show sub totals in matrix visual

[filexsundeep09]

Hi Experts, can you please help me to show the subtotals in the matrix visual, while I am trying to implement I am getting some differences. I am attaching two screenshots below, please can anyone help me to solve this issue and move my work smoothly?

Requried:

Getting this:

Regards,
sundeep

[PaulDBrown]

"that I have shared ss"

Sorry, I don't understand what you mean. To be able to help we need to know the structure of the data

[PaulDBrown]

Please share some sample, non-confidential data or a link to a sanitized PBIX file

[filexsundeep09]

I am having a  sample template that I have shared ss and I am trying to remap in power bi can you plz try to help me to solve this?

[filexsundeep09]

Employee Name	position	project no	project name
san	assco	a201	chemical indus
rushi	assco	a211	iron indust
kish	assco	a201	chemical indus
kittu	bussiness	a201	chemical indus
chekri	bussiness	a211	iron indust

[filexsundeep09]

whenever I selected project no, it will display only current project positions and employee details

[Anonymous · Accepted solution]

Hi @filexsundeep09 

You can create a slicer and apply the field [project no] on the slicer, then select one or multiple project no to filter the data on the other visuals.

Best Regards