Possible to group columns with main header?

[Anonymous]

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 trying to convey. The question is if these top columns can be created somehow? and if so, how to do it?

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

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

Regards,

Cherie

[Anonymous]

Hi @v-cherch-msft ,

I would like to accept your reply as solution, however i forgot to mention in my real life example (not the sample data).

I have this table:

Each column in this table is based on a calculated measure that combine multiple columns in the data model. Therefore, i am not able to create a conditional column that can distinguish between data used for KPI 1 and KPI 2. 

Is it possible to do this grouping of columns based on measures rather than columns?

So i can group all KPI's together at the top for easier visual consumption.

sorry for not being specific enough with first example.

[v-cherch-msft]

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]

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]

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:

Header	Header SortBy	Measure Name	Measure Name SortBy
Sales	1	Product A	1
Sales	1	Product B	2
Sales	1	Product C	3
Customer By Importance	2	high	4
Customer By Importance	2	low	5

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.