topic Re: Merge Cells in Matrix in DAX Commands and Tips

Merge Cells in Matrix

BSathya — Thu, 07 May 2026 10:19:22 GMT

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.

Re: Merge Cells in Matrix

krishnakanth240 — Thu, 07 May 2026 11:45:35 GMT

Hi BSathya

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

Re: Merge Cells in Matrix

MFelix — Thu, 07 May 2026 11:49:09 GMT

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.

Re: Merge Cells in Matrix

pcoley — Fri, 08 May 2026 00:01:10 GMT

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:

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.

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.

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.

Re: Merge Cells in Matrix

cengizhanarslan — Fri, 08 May 2026 19:26:30 GMT

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.

Re: Merge Cells in Matrix

v-menakakota — Mon, 11 May 2026 04:11:14 GMT

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

Re: Merge Cells in Matrix

v-menakakota — Thu, 14 May 2026 04:13:22 GMT

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