Forum Discussion
Sorting by Column not displayed when using a Field Parameter
Hi sassy0112
Sort Column in the Data Model (Both the columns used in the Field Parameter)
Ensure your columns (e.g., Month-Year, Week-Year) have corresponding numeric sort columns (like MonthNumber or WeekNumber) defined in your data model.
Use Power BI’s Sort by Column feature to link the display column to the numeric sort column.
This should follow even when switiching the fields
Hi sassy0112
Sort Column in the Data Model (Both the columns used in the Field Parameter)
Ensure your columns (e.g., Month-Year, Week-Year) have corresponding numeric sort columns (like MonthNumber or WeekNumber) defined in your data model.
Use Power BI’s Sort by Column feature to link the display column to the numeric sort column.
This should follow even when switiching the fields
I realized what I was doing wrong, and your solution worked! In column sort I thought you simply picked the column to sort by, when in fact you are selecting the display column, then selecting the column to sort that column by. Once I realized that it works like a charm.