Forum Discussion
Sorting By column turning off
No, I don't think I can really ... it's a lot of data and all of it is company sensitive. The jist is, say I have year and month...we sort this by a column with values like 2021.01, 2021.02 where 2021 is the year and the digits after the period are month numbers.
Without the Sort by set the charts and tables sort 2021-Apr, 2021-Aug and so on... when I do Sort By, we get the desired results which is 2021-Jan, 2021-Feb... users can change the sort but if they sort ascending or descending on the month and year it sorts by the numeric values intended.
What is happening is that after we update the dataset (we have several reports attached to a single dataset) the Sort By is lost and sorting ascending or descending simply reverts to alphabetical sorting. Frankly, I think it's a bug.
Hi Anonymous,
Perhaps you can consider creating a standalone sorting table with raw table category field and index. Then you can link raw table fields and use new sort table fields on your visuals to replace the raw axis fields.
Custom Sorting in Power BI
Regards,
Xiaoxin Sheng