Forum Discussion

Pfutch1's avatar
Pfutch1
Frequent Visitor
1 year ago

SortByColumn property set to an invalid column ID

I am trying to sort my Week-Year column of my date table, by a column called "Sorting Order - Weeks". However, for this specific column I am getting the following error. "The column "Week _ Year (...
Need Help
tackytechtom's avatar
tackytechtom
Icon for Most Valuable Professional rankMost Valuable Professional
1 year ago

Hi Pfutch1 ,

 

For the sort by column feature to work, there needs to be unique values in the Week _ Year (Order) i Format: (W## - YYY)' column or each value in the Week-Year column. So there should not be the same value in the sorting column for different Week-Year values. 
Also, check that there are no NULLS or BLANKS in the sorting column. 

 

If all of this is ok, try closing and reopening Power BI. It might just be a cached thing.

 

Let me know how this goes 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/ 

Pfutch1's avatar
Pfutch1
Frequent Visitor
1 year ago

Hi Tom,

I closed and re-opened that PBIX file.  I double checked that there is only one value in my sort order column for each Week-Year value, and there are no nulls or blanks in either column.  Still not working though unfortunately