Forum Discussion

Bartek_Smith's avatar
Bartek_Smith
Regular Visitor
5 months ago
Solved

Sorting case

I used to use Tabelau for years, but now in my company we are going to change our BI soft to PowerBI. Preapering to migration I start to recognize PowerBI features, but I have huge problem with one o...
Need Help
Show and Tell
  • danextian's avatar
    danextian
    5 months ago

    hI Bartek_Smith 

    I know it is counter-intuitive but the only solution is, what others have already mentioned, is to use a custom sort by column. I would duplicate the year column. In the image below, visual 1 users Year2 column sorted by another column while the second visual has no custom sort

    Please see the attached pbix.

     

rohit1991's avatar
rohit1991
Super User
5 months ago

Hii Bartek_Smith 

 

In Power BI Matrix, column sorting (like Year 23/24/25) does not work from the visual header like Tableau. You must control sorting from the data model. If Year is text (e.g., 23/24/25), create a numeric sort column (e.g., 2023=1, 2024=2, 2025=3 or actual year number), then select the Year column >> Column tools >> Sort by Column >> choose the numeric sort column. Sorting by another column fails due to circular dependency if both columns depend on each other. After setting proper “Sort by Column” in the model, the Matrix will respect ascending/descending order correctly.