Forum Discussion
Solved
Power BI Not Sorting column
Hi all, I have below data in which I am trying to sort Time Period column by Time Period sort column. but getting below issue this is really frustrating as I have no duplicate values. ...
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
yashwant101,
Do you have these 2 columns in a separate sort table or are these 2 tables part of a table larger table where each time period has one period sort mapped to it?