Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Merging cells of table in Power BI Matrix visualization

I have a data that collected monthly and quarterly. Now I want to visualize it using Matrix. However, I want to show the quarterly data by merging the cells together as shown in the images below.   ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    It is not supported to you to merge cells by columns in Matrix currently in Power BI.

    Try to add your hierachy in Matrix Rows.

    If your sample is as below, try to fill up the values in Documents and Books, then select ID and Value column and use Pivote function in Power Query Editor.

    New Table:

    Build a martix visual as below, and you need to turn off Stepped layout in Rowheader in Format.

    Result:

    Best Regards,

    Rico Zhou

     

    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
5 years ago

Hi Anonymous 

It is not supported to you to merge cells by columns in Matrix currently in Power BI.

Try to add your hierachy in Matrix Rows.

If your sample is as below, try to fill up the values in Documents and Books, then select ID and Value column and use Pivote function in Power Query Editor.

New Table:

Build a martix visual as below, and you need to turn off Stepped layout in Rowheader in Format.

Result:

Best Regards,

Rico Zhou

 

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