cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Surafel
Helper I
Helper I

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.

 

For example, my visualziation is currenly looking like below. 

Power BI merge rows 1.PNG

 

And I want to make it look like the following:

 

Power BI merge rows.PNG

 

Can anyone please tell me if it is possible to achieve this in Power BI Matrix visualization? 

 

 

1 ACCEPTED SOLUTION
RicoZhou
Community Support
Community Support

Hi @Surafel 

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.

2.png

New Table:

1.png

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

1.png

Result:

3.png

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. 

View solution in original post

2 REPLIES 2
RicoZhou
Community Support
Community Support

Hi @Surafel 

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.

2.png

New Table:

1.png

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

1.png

Result:

3.png

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. 

View solution in original post

amitchandak
Super User IV
Super User IV

@Surafel , I doubt you can merge like you have shown. You can have Qtr(along with Mon year) also on the column and there you get sub total of the qtr.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors