Create pivot table visual

[asparagus1_]

Hi everyone,

I’m trying to create a visual that resembles the following table:

Category 1	Category 2	Category 3	Jan-24	Feb-24	Mar-24
A2	B2	C2	33	11	4
A3	B3	C3	44	22	111
A4	B4	C4	5	6	7

I want users to dynamically select which columns for Category 1, Category 2, etc., should be displayed. I've achieved this using a parameter table. However, when users make selections from the slicer, the categories appear in a hierarchy within the matrix visual. My goal is to have them displayed as individual columns instead.

Any suggestions on how to achieve this column-by-column view? Thank you!

[SamWiseOwl · Accepted solution]

Hi @asparagus1_ 

Have you the tabular view in the matrix with repeat headers on.

This puts them in seperate columns.

[_AAndrade · Accepted solution]

Hi @asparagus1_,

Take a look at this gif:

I'm attaching a pbix file with this solution.

[asparagus1_]

Thank you!

[SamWiseOwl · Accepted solution]

Hi @asparagus1_ 

Have you the tabular view in the matrix with repeat headers on.

This puts them in seperate columns.

[asparagus1_]

Thank you!