Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Merging cells in a table

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.

 

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

4 Replies

  • MattiaFratello's avatar
    MattiaFratello
    Super User
    1 year ago

    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's avatar
      Anonymous
      Not applicable
      1 year ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      Anonymous
      Not applicable
      1 year ago

      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.