Forum Discussion
Matrix - formatting and Sorting
Hi 101Mathew ,
This behavior is a current limitation of the Matrix visual. Power BI doesn’t support applying different formatting at individual column hierarchy levels such as alternating header colors or thicker vertical gridline, and column groups can’t be manually reordered. The order of hierarchy fields is always driven by the model’s sort logic , alphabetical or Sort by Column. While measures can be reordered by drag and drop in the Values well, this capability does not apply to column hierarchy fields.As a workaround, you can use a dedicated sort column in the model, or replace the column hierarchy with individual measures so you can control their order explicitly. Features like Field Parameters or dynamic format strings can help with dynamic selection or value formatting, but they don’t solve the core limitations around hierarchy level formatting or custom column ordering in a Matrix at this time.
Hi 101Mathew ,
This behavior is a current limitation of the Matrix visual. Power BI doesn’t support applying different formatting at individual column hierarchy levels such as alternating header colors or thicker vertical gridline, and column groups can’t be manually reordered. The order of hierarchy fields is always driven by the model’s sort logic , alphabetical or Sort by Column. While measures can be reordered by drag and drop in the Values well, this capability does not apply to column hierarchy fields.
As a workaround, you can use a dedicated sort column in the model, or replace the column hierarchy with individual measures so you can control their order explicitly. Features like Field Parameters or dynamic format strings can help with dynamic selection or value formatting, but they don’t solve the core limitations around hierarchy level formatting or custom column ordering in a Matrix at this time.
Thank you, this was my findings also, I was wondering if there was some type of solution - I've raised an suggestion in the Idea's section yesterday for this -
My issue is compounded by the need to switch the measures into rows
