Forum Discussion

ERing's avatar
ERing
Post Partisan
1 year ago
Solved

How to create Matrix Headers?

I'm stuck and still looking for help on how to create Matrix Headers like in the visual below. I've been suggested using parameters, calculation groups, and a disconnected table with switch measure, ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi ERing 


    Aside from what ERing  mentioned, you can create a headers table using DAX or M (via the enter data option). The key point is that a physical column is required to assign the output of a measure. Field parameters are suitable if your goal is to choose which columns to display, but they are not compatible with hierarchical structures. Please see the attached pbix.

     

     

     

  • OwenAuger's avatar
    OwenAuger
    1 year ago

    Hi again ERing ,

    Good point! Columns with all blanks are hidden by default.

     

    I would recommend selecting "Show items with no data" on the Column fields only (assuming that is where the measures are placed).

     

    This will ensure that all measure columns are always displayed regardless, without introducing unwanted nonblank measure values.

     

    Does this work for you?

danextian's avatar
danextian
Super User
1 year ago

Hi ERing 


Aside from what ERing  mentioned, you can create a headers table using DAX or M (via the enter data option). The key point is that a physical column is required to assign the output of a measure. Field parameters are suitable if your goal is to choose which columns to display, but they are not compatible with hierarchical structures. Please see the attached pbix.