Forum Discussion

Narukkp's avatar
Narukkp
Helper V
7 years ago
Solved

Merge cells in tabular visualization

Hi Team, Can we merge the cell data in power bi. I mean how we do in Excel. PFB existing data and required output   Existing data :   Country City Year Sales Target Reached ...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi Narukkp ,

    You can implement it using a matrix.

     

    Drag the column to the Fields -- > turn off the option of Stepped layout -- > turn off the option of Row subtotals -- > expend all down one value in the hierarchy

    Best Regards,

    Xue Ding 

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

     

v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi Narukkp ,

You can implement it using a matrix.

 

Drag the column to the Fields -- > turn off the option of Stepped layout -- > turn off the option of Row subtotals -- > expend all down one value in the hierarchy

Best Regards,

Xue Ding 

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

 

  • Narukkp's avatar
    Narukkp
    Helper V
    7 years ago

    Thank you

  • hi_cunglamdata's avatar
    hi_cunglamdata
    New Member
    2 years ago

    Hi Xue Ding,

    I have tried your instructions (Off 'Stepped layout', Off 'Row Subtotal' and Click on 'At the lowest level of data') but the result shows only 1 row (instead of 4 rows as in the below images).

    Please help to check.
    Thank you so much.
    Kha