Merge Cells in Matrix

[BSathya]

Hello Everyone,
I am trying to merge the cells in Matrix visual like in excel but couldn't find an option. Can you help with options if available in power query editor or by DAX please.

[krishnakanth240 · Accepted solution]

Hi @BSathya 

Can you share screenshot of how you want with the sample data

[cengizhanarslan]

Merging cells in a Matrix visual is not supported in Power BI. The only visual in Power BI that supports true cell merging is the Paginated Report (RDL), which is purpose-built for pixel-perfect layouts including merged cells, grouped headers, and precise column spanning.

[v-menakakota]

Hi @BSathya   ,
Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @cengizhanarslan  and @MFelix   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team

[v-menakakota]

Hi @BSathya ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team

[pcoley]

@BSathya 
Unfortunately, Power BI does not have a native "Merge Cells" feature like Excel. Power BI visuals (Table and Matrix) work very differently from spreadsheets — they are designed for dynamic data analysis rather than pixel-perfect formatting.

What you can do instead:

1. For Row Grouping (most common request) Put multiple fields in the Rows section of the Matrix. Then go to Format your visual > Row headers and:

   • Turn Off "Stepped layout"
   • Turn On "Repeat row headers" (if needed)

   This gives a grouped look similar to merged cells.

2. Blank out repeated values using DAX (very popular workaround) Create a measure like this:

   dax

   Display Category = 
   IF (
       ISINSCOPE ( YourTable[SubCategory] ),
       YourTable[SubCategory],
       IF (
           ISINSCOPE ( YourTable[Category] ),
           YourTable[Category],
           BLANK()
       )
   )

   Then use this measure in the visual instead of the original column. This creates a "merged" visual effect by hiding repeated parent values.

3. For Column Headers There is currently no native way to merge column headers like in Excel. You have to live with the standard hierarchical layout.

[MFelix · Accepted solution]

Hi @BSathya ,

Merging the cell in Matrix or table visual is not possible has a definition that you turn on/off, however if you want to have the merge of the header columns that can be done using a hierarchy in the columns / rows that will show the values of the header or rows in a merge way.

[krishnakanth240 · Accepted solution]

Hi @BSathya 

Can you share screenshot of how you want with the sample data