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
Super UserHi 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, Thank you for the response. This doesn't work for me for some reason. I have a sort key in the dimDate table, which are YYYYMM and YYYYWW. When I do a column sort on the table it ignores it. I'm not sure if this is because I'm using a field parameter in the chart.