Forum Discussion

DAX_merchant's avatar
DAX_merchant
Icon for Helper II rankHelper II
1 year ago
Solved

Sorting a matrix with multiple measures by column

I have a matrix with columns as years, rows as stores and two measures populating each column: employees and total sales.    I want to be able to sort the rows of the matrix by any year, not only t...
Need Help
  • v-echaithra's avatar
    v-echaithra
    1 year ago

    Hi DAX_merchant ,

    Thanks for the update. Unfortunately, Power BI does not currently support fixed or persistent column widths in matrix visuals. The column width is automatically calculated based on the data in each column and is recalculated any time the visual is refreshed or slicers are changed. There is no built-in setting to lock or fix column widths.
    I tried to recreate the issue on my end, and it worked fine. This behavior is likely unintended or a setting that hasn’t been fully integrated into Power BI Desktop yet.
    If this feature is important to you, consider submitting a suggestion on Fabric Ideas or voting for an existing one.
    https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas

    If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.

    Regards,
    Chaithra.



v-echaithra's avatar
v-echaithra
Icon for Community Support rankCommunity Support
1 year ago

HI DAX_merchant ,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.