Forum Discussion
Table Visual Grouped Column Headers
I have a table visual with 92 columns with 1500 rows. Each column has it's own column header for example
| Customer Name | Customer State | Customer Country | Car Make | Car Model | Car Year Made |
| Dan | Iowa | USA | Honda | Civic | 2018 |
| Matt | Minnesota | USA | Toyota | Camry | 1998 |
I would like the table visual to group the first 3 columns and the last 3 columns with different Group headers without converting it into a matrix/pivot, such that:
Customer Information Car Information
| Name | State | Country | Make | Model | Year |
| Dan | Iowa | USA | Honda | Civic | 2018 |
| Matt | Minnesota | USA | Toyota | Camry | 1998 |
I have found solutions for pivot/matrix but not plain ol' Table visual.
Thank you
5 Replies
That's all you - use Power Query for these transforms, or calculated columns.
Create these new columns in Power Query by concatenating the separate column values then display them in your table.
Phil
Hi shintamanning ,
You can try merge columns:The final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I have tried merge columns but users do not want the column to be merged. They want another heading above the column heading to visually organize the columns below.
Again, this is all you. Create calculated columns or Groups that hold your desired hierarchy levels.
