Forum Discussion
Solved
Matrix columns formatting
I have a matrix showing products on the left hand side and corresponding products bought with those items accross the columns. There are multiple things I'd like to do but cant see how to i...
I see what you’re trying to do. Let me go through your points one by one.
- For sorting, the matrix in Power BI doesn’t let you sort the column headers by values. You can do this for rows but not for columns. The closest option is to either swap rows and columns so that you can sort by the measure, or reshape the data so it’s in a “left product / right product / count” format. That way you can sort it properly in a table or chart.
- For column widths, you can fix them. Just select the matrix, open the format pane, turn off auto-size for column headers, and then adjust the widths manually. Once that’s done, they’ll stay the same even if you use slicers.
- For rotating the column headers, the built-in matrix doesn’t support this. If you really need them vertical, you’ll have to use something like the Deneb custom visual or export it into Excel or Paginated Reports where rotated headers are possible.
Hope this clears it up.
If this post helps, please consider marking it as a solution so others can find it more easily.
Regards,
