Forum Discussion
Transpose table in report visual
This is how my table looks like:
In the 1st column, we have the year, and in the n remaining columns the indicators.
I'd like to build a matrix visual with the indicators in the rows and years in columns.
Now, I know I can unpivot all the columns except the year in the query editor. But the structure above is necessary to build charts where the x-axis is the year and the series is only one or two indicators.
Is there a way (a measure, calculated table or other) to build the matrix I need?
Thanks!
The source data should always be equal. But you are right. Transformation steps won't be duplicated.
If this is your intenstion use reference (one below) instead of duplicate.
Then the source of your second query isn't the original source (database?) but the first query.
Every transformation step will be "forwarded" to your new query. So you'll keep all your changes and only unpivot the second query.
9 Replies
Hi webportal,
Agree with supder, the current table structure doesn't match the matrix visual. To achieve your goal, you have to unpivot columns, as it is not available to do that using DAX, as supder mentioned, the best choice is duplicating your source table.
Best regards,
Yuliana GuHi,
I know it doens't match the matrix. The problem is that by duplicating and unpivoting the table, I'll have two tables which are not synchronized. That is, changes in the original table will not be reflected on the tranposed table.
The source data should always be equal. But you are right. Transformation steps won't be duplicated.
If this is your intenstion use reference (one below) instead of duplicate.
Then the source of your second query isn't the original source (database?) but the first query.
Every transformation step will be "forwarded" to your new query. So you'll keep all your changes and only unpivot the second query.
