Solved: Add a custom merged header

jpchen · ‎10-20-2021

Is there a easy way to create the merged header in either table or matrix in Power BI?

For example, Census: Census 2010 & Census 2020; Gender: Female, Male & Total (as below).

mahoneypat · ‎10-20-2021

You could make a new column and concatenate "Census " & Table[Year] in your table and use that new column as the top one in your matrix columns.

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

mahoneypat · ‎10-20-2021

You could make a new column and concatenate "Census " & Table[Year] in your table and use that new column as the top one in your matrix columns.

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Add a custom merged header