Add common headings for two columns but still specify the # and % signs for the individual columns

[PBIFanHook7]

I have a report with a table visual with individual column headings. I would like to know if/how I can change the columns to show multiple (two) columns under a common column heading, like in the screenshot below. Refer to columns C/D, E/F, G/H, and I/J. I still would like to show the # sign and % sign for the individual columns as showned in the below screenshot. I would like to do this in the current table visual, if possible. If not possible, please let me know how I can do it in a matrix or other visual. 

Thanks in advance for all help and suggestions. 

[v-pgoloju]

Hi @PBIFanHook7,

Just following up to see if the Response provided was helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @PBIFanHook7,

Just following up to see if the Response provided was helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju · Accepted solution]

Hi @PBIFanHook7,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @Ritaf1983 and @Greg_Deckler  for prompt and helpful responses.

I’ve tried to reproduce the scenario using the Power query. Please review and adjust it according to your data source. If the issue still persists, feel free to share more details, and we’ll be happy to assist further.

Thanks & Regards,

Prasanna Kumar

[PBIFanHook7]

I tried opening your Matrix_Visual.pbix file. It is showing me the below screenshot report. I don't see the Matrix Report with the # sign and % sign for the individual column names as showned in the above screenshot which I provided. Please let me know, if the below is what I should be seeing, or am I missing something like another report (page) or if I need to sign in to power bi online. I am working in power bi desktop only.  Thanks for your help. 

[v-pgoloju]

Hi @PBIFanHook7,

I’ve reproduced a similar scenario in Power Query using pivot and unpivot transformations, matching your requirement. Please check the applied steps once and adjust them as needed according to your data source.

If the issue still persists or you’re seeing a different output, feel free to share more details or a sample dataset I’ll be happy to take another look and help further.

Thanks & Regards,

Prasanna Kumar

[PBIFanHook7]

Okay, I have converted the table to a matrix. My matrix setup is in the below screenshot. (I currently don't have column B as part of the matrix.) For columns C/D, E/F, G/H, and I/J, I still would like to show the # sign and % sign for the individual column names as showned in the above screenshot. Thanks for all help and suggestions. 

[Greg_Deckler]

@PBIFanHook7 You can do that using a Matrix visual instead.

[PBIFanHook7]

Greg, thanks for your suggestions. I have converted the table to a matrix. My matrix setup is in the below screenshot. (I currently don't have column B as part of the matrix.) For columns C/D, E/F, G/H, and I/J, I still would like to show the # sign and % sign for the individual column names as showned in the above screenshot. Thanks for all help and suggestions. 

[Ritaf1983]

Hi @PBIFanHook7 

You can achieve this layout by using a Matrix visual instead of a Table.

In order to display common headers (e.g., “Children with Siblings”) with two subcolumns (# and %), your data model needs to include a column such as [Type of number], where each row is classified as either “#” or “%.”

Then, instead of dragging the raw value field, create a measure:

Value_ = SUM('Table'[Value])

Apply a dynamic format string to that measure:

IF(SELECTEDVALUE('Table'[Type of number]) = "#", "0", "0%")

In the Matrix visual:

Place the main category (e.g., “Children with Siblings”) under Columns

Place [Type of number] under it (so you get both # and % subcolumns)

Use Value_ as the value measure

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[PBIFanHook7]

Rita, I just want to say thank you for the power bi example. I got pulled away from this task. I will look closer at it soon. What you provided seems to be what I need, but I want to work through first. Then I will respond again.