Forum Discussion

BSathya's avatar
BSathya
New Member
3 months ago
Solved

Merge Cells in Matrix

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.

  • MFelix's avatar
    MFelix
    3 months ago

    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.

     

     



     

     

6 Replies

  • MFelix's avatar
    MFelix
    Super User
    3 months ago

    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.

     

     



     

     

  • cengizhanarslan's avatar
    cengizhanarslan
    Super User
    3 months ago

    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's avatar
      v-menakakota
      Community Support
      3 months ago

      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's avatar
        v-menakakota
        Community Support
        3 months ago

        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's avatar
    pcoley
    Super User
    3 months ago

    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.