Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Possible to group columns with main header?

Is it possible to create a group of columns that are together, or do i need to make a custom box on top of the grouped columns and is not linked to the table?   Here below is a visual of what i am ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

     

    You may transform your data table like below and then use Matrix visual to get it.

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous 

 

It's impossible to group them based on measures because measures are dynamic and they cannot be used in matrix columns.

 

Regards,

Cherie

Juliet1's avatar
Juliet1
Frequent Visitor
3 years ago

Hi v-cherch-msft

By chance, after 4 year, is it possible to create a share header for 2 or more columns created by measures?

Best Regards

  • JillianK's avatar
    JillianK
    Frequent Visitor
    3 years ago

    Yes, but it's pain. I'm doing this from memory, so I may get some details wrong, but you should be able to figure it out.

    Go to Enter Data and enter the table:

    HeaderHeader SortByMeasure NameMeasure Name SortBy
    Sales1Product A1
    Sales1Product B2
    Sales1Product C3
    Customer By Importance2high4
    Customer By Importance2low5

     

    The create a matrix visual where you have Header and Measure Name both in the Column field, and Country in the rows (if I recall correctly). 

    Then create a measure for the visual

    = SWITCH( SELECTEDVALUE(Measure Name),

    "Product A", [Product A], 

    "Product B", [Product B], 

    "Product C", [Product C], 

    "High", [High], 

    "Low", [Low])

    and drag that measure into the values.