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, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra E

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

    Hello,

    Apologies for the late response. The solution you gave is not satisfactory as my date ranges can change depending on the time of year the report is viewed. Besides, it has the same issue as the current method that I already described in my innitial question which is that the button size cant be dynamic while I know that my column widths are, depending on the size of the region I am slicing on.

     

    It is possible that I am misunderstanding your solution but having buttons is more difficult than having a slicer if the number of choices is dynamic (with a slicer at least, I know that when my report is refreshed, the disconnected table I made will update while the bookmarks will have to be done manually, to my understanding...)

    EDIT: Perhaps a more appropriate question would be: is it possible for force a certain column width in a matrix that will persist when the visual is refreshed (changing slicer selection or report refresh)?