Forum Discussion
Helper IISorting a matrix with multiple measures by column
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_ideasIf 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.
Community SupportHi DAX_merchant ,
Thank you for reaching out to Microsoft Community.
You can’t extract the clicked column header from a matrix.
Using buttons, bookmarks, or rethinking the visual layout can be a workaround.
Replace the slicer with a set of buttons and bookmarks:
Create buttons for each year.
Each button selects a year via slicer sync or bookmarks with slicer pre-selected.
Style them to look like clickable headers (stacked horizontally above the matrix).
This doesn’t solve column highlighting but provides a cleaner, fixed layout.
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