Table Columns Suggestion

[Anonymous]

Hi all,

I want to ask - is it possible to create a table with column like this arrangment?

I want to spread the year horizontal wise and the columns type A, type B, and and type C will contains numeric information.

If it is possible, can you guide me on how to make such arrangement?

Best regards,

Bona

[Anonymous · Accepted solution]

Hi  @Anonymous ,

You can refer to the link below:

Solved: Matrix column header/label custom group - Microsoft Power BI Community

Creating a “custom” or “hybrid” matrix in PowerBI - Microsoft Power BI Community

Best Regards,

Liu Yang

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

[Anonymous]

Hi, Thank you for your reply. Let me check these links and see whether this is helpful or not.

Best regards,

Bona

[Anonymous]

Let me check this because this is not something that I have ever used.

Thank you for the input!

[Anonymous]

I have tried using the Matrix... But I cannot make the columns to be like in the picture I share.

I put two data source as the columns but it ends up with Power BI only using one of it as the column.

[danextian]

Did you expand the column into the next level of the hierarchy?

[danextian]

Hi @Anonymous ,

Have you tried using the matrix visual?

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual