Sort Columns in Matrix by non-visible column (dataset is separate pbix)

[Anonymous]

Hi AllMy dataset is a spearate PBIX as lotsa of reports use the same dataset

I have this dimension table and it sorts in Year/SeasonNo

I add a matrix and columns are not sorted by season

All the column tools are disabled too

This is dead easy and obvious in SSRS. How on earth do I di it in PowerBI

Thanks

Mark

[Greg_Deckler]

@Anonymous Select your Season column. In Column tools, set your Sort by column to your YearSeasonNoSort column.

Dead easy... 🙂