Forum Discussion
Solved
matrix column header order -- in live SSAS Tabular connection
hi folks, I'd like to sort numeric (or alphanumeric) column headers say YYYYMM (202210) in Matrix components BUT without adding DAX additional code to the project, as everything is coming from Anal...
looks like sorting is available on Rows but not on Columns, in hte PBI Matrix visual. Once changing the data on Rows, I'm able to properly sort now. thank you, folks --
yeah, I mentioned that
"the column in the SSAS Tabular project already has the "sort By" property set, but that does not seem to be respected by PowerBI." -- so a tad unclear for now.
At this time, I have changed the layout so that the sortable columns are put on the rows, which the PBI matrix visual supports.
thank you --