Forum Discussion
Adjust the column width dynamically based on the number of columns selected.
In the display/disconnected table, you can just add another column whether the row is for actual, budget or difference and use that in a slicer.
Community SupportHi Ignite190,
Because the matrix uses a disconnected table and a single dynamic measure, native column sorting from the visual header won't work, Power BI only lets you sort by fields actually shown in the visual, not by dynamically switched measures. To fix this, you can add a SortOrder column to the disconnected table and set Sort by Column in the model to control the column order. If you need dynamic sorting based on values, a possible workaround is to create separate ranking measures for each metric and use them in the row hierarchy for sorting. However, matrix columns can't be dynamically sorted when measures use a SWITCH pattern. So, it's best to manage the column order using a predefined sort column in the header table.
Thank you.