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.
  • krishnakanth240's avatar
    krishnakanth240
    3 months ago

    Hi BSathya 

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

  • 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.

     

     



     

     

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.