Forum Discussion

Laxman222's avatar
Laxman222
Regular Visitor
1 year ago
Solved

How to get double headers in power BI matrix

How to get double headers in power BI matrix visualization as per the attached screensho

t.

  • lbendlin's avatar
    lbendlin
    1 year ago

    Create a disconnected reference table with the measure names and use that in the column headers.

5 Replies

  • put two fields in the column well of the matrix and then expand the columns to next level.

  • dharmendars007's avatar
    dharmendars007
    Icon for Memorable Member rankMemorable Member

    Hello Laxman222 , 

     

    Are you looking something like this..than you add two columns and expand it..

     

    Example - If you want the first header to show a field like "Region" and the second header to show "Month", drag Region first and then Month into the Columns well.This will give you a double header with the months nested under each region.

     

    If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

     

    Thank You

    Dharmendar S

    LinkedIN 

     

     

    • Laxman222's avatar
      Laxman222
      Regular Visitor

      But The top header is dynamic and the below header is measures

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User

        Create a disconnected reference table with the measure names and use that in the column headers.

  • dharmendars007's avatar
    dharmendars007
    Icon for Memorable Member rankMemorable Member

    Hello Laxman222 , 

     

    Are you looking something like this..than you add two columns and expand it..

     

    Example - If you want the first header to show a field like "Region" and the second header to show "Month", drag Region first and then Month into the Columns well.This will give you a double header with the months nested under each region.

     

    If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

     

    Thank You

    Dharmendar S

    LinkedIN