Forum Discussion
Power BI Not Sorting column
yashwant101,
Here's what you can do:
1. Change the data type of column to whole number. Text will also sort it but based on ASCII ordering
2. Easiest, Quickest, Safest for long-term model development: Create a separate time period sort order table with just these 2 columns, make sure sort order column is whole number. Create a relationship between any table's time period to this table's time period and use this table in visuals. Filtering for the relationship would be uni-directional from sort order table to any other table with it.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn
Hi all,
Thank you for your responses. It might have been some transient issue. I let Power BI sleep over it and now I am able to sort without any change.😊
I'm curious how sorting works as intended when the sort column is text, not numeric. Text won't sort the periods the way you want.
Also why an answer was chosen as a solution when you say you did nothing to 'fix' the issue?
Puzzled.
Phil
