Displaying a column's fields as column headers in a table

[Micgig]

Hi everyone,

Hope you are well.

As captioned in the title, I'd like to display a few columns normally and then from a certain point of the table on, I'd like to have another column be displayed as X axis.

Let's say I have 3 columns of the following type:

Number	Date	Color
1	January 1	Red
2	January 2	Yellow
3	January 3	Blue

What I'd like to display in "table" or "matrix" should be something like this:

Number	Date	Red	Yellow	Blue
1	January 1	X
2	January 2		X

Is there a way on PowerBI to arrange this?

Thank you so much!

Michele

[TheoC · Accepted solution]

@Micgig, 

You should be able to use the Matrix visual and drag the "Color" field into the "Columns" of the visual's fields.  It will result in each colour being the column title.

Hope this helps 🙂