Merging cells in a table

[Anonymous]

Hello,

I need a healp with visualisation, At the momment I have this kind of header picture 1.  

picture 1:

I would like to achieve this kind of header below:

Picture 2

it would be great is "years"(in the red circle) would change in the table as a user click in the slicer as well...(a Dynamic Header) , not sure if it's achievable... but headers is my priority at the moment. Thankyou guys you are doing a great work for all of us who need a help.

[Anonymous]

Hi @Anonymous 

Please try this:
Here I create a set of sample:

Table:

Then add a matrix:

Click the Expend all down one level in the hierachy until the last level:

Then add a Slicer, so that the result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hello, Thank you for support, appretiate it.  I tried matrix, and could not get the result the same I wanted. But I improvised , I mannaged it this way below. headers are in red circle and years are dynamic , the rest is text boxes. it met expectations.

[MattiaFratello]

Hi @Anonymous , 

Add in a Matrix in the column section your columns: 

- type of cases

- type of supervision

- year

Expand all down

Play with the Format for colors, totals, etc

[Anonymous]

Matrix won't help, look closer in pictures, matrix won't make it like this, basically Power BI doesnt have abilities to manage headers, can't hide headers,unless I create an other layer above or change text of header with background, developers of Power BI should look into it.