Forum Discussion

BSathya's avatar
BSathya
New Member
4 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
    4 months ago

    Hi BSathya 

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

  • MFelix's avatar
    MFelix
    4 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
Icon for Super User rankSuper User
4 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
    Icon for Community Support rankCommunity 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
      Icon for Community Support rankCommunity 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