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
Community Supporthi Arshadjehan
You could try this way as below:
Step1:
Add a dim categories table as below:
Dim categories = UNION(VALUES('Table'[categories]),ROW("categories","Average of Actual"))Then create a relationship with basic fact table
Step2:
Create a measrue as below logic:
or
Result:
And here is sample pbix file, please try it.
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?
- v-lili6-msft
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