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.

     

FBergamaschi's avatar
FBergamaschi
Super User
5 months ago

Hi Bartek_Smith,

sort by column is the way to go

 

You can do the following

 

1 - duplicate your calendar query in Power Query

2 - isolate the calendar year column, rmeove duplicates and sort descending

3 - merge the query to have a sorting column done before you load data in Tabular

 

 

 

Now you have a column you can use for sort by column and no circular issue

 

 

 

 

 

 

 

Attanched a pbix for reference where you can find the visual and all steps done

 

Best

 

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

  • Bartek_Smith's avatar
    Bartek_Smith
    Regular Visitor
    5 months ago

    Hi,

    Thx it works. I didn't expected that there the table copy is needed. A lot of mysterius is still ahead me in PowerBi xD