Forum Discussion
Helper IGetting Selected Columns for Matrix Visual
hi Arshadjehan
If so, you could only try these two workaround:
1. Unpivot the these six columns and then get it as above.
https://radacad.com/pivot-and-unpivot-with-power-bi
2. disable the "Word wrap" in Format-> Column headers of matrix, then reduce the column width to 0 manually for year 2016/2017/2018.
Regards,
Lin
Helper IThanks v-lili6-msft for detailed answer.
But "Categories" you used in sample fact table as ROWS, are actualy columns in my table.
Here is the sample snapshot;
How can I refer to these columns, and get the similar solution you gave, withing the matrix I pointed to in my first post?
Community Supporthi Arshadjehan
If so, you could only try these two workaround:
1. Unpivot the these six columns and then get it as above.
https://radacad.com/pivot-and-unpivot-with-power-bi
2. disable the "Word wrap" in Format-> Column headers of matrix, then reduce the column width to 0 manually for year 2016/2017/2018.
Regards,
Lin