Forum Discussion
Possible to group columns with main header?
Hi Anonymous
You may transform your data table like below and then use Matrix visual to get it.
Regards,
Cherie
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
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.