Forum Discussion
Solved
Displaying a column's fields as column headers in a table
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
