Forum Discussion

sassy0112's avatar
sassy0112
Frequent Visitor
1 year ago
Solved

Sorting by Column not displayed when using a Field Parameter

Hi,   I have a line graph that uses a field parameter to switch the x-axis between date, month-year, and week-year. I want to sort on a differnt column than I'm displaying in the graph. I know it i...
Need Help
  • MohamedFowzan1's avatar
    MohamedFowzan1
    1 year ago

    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