Problems with UNICHAR Sort by Columns Approach ⚠️

In this video, we will discuss the nuances of using UNICHAR Sort by Column trick! The trick was discussed in the last video. This is a quick follow-up to that video.
Blog Link 1 - www.sqlbi.com/articles/sortin...
Blog Link 2 - www.sqlbi.com/articles/creati...
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/never-do-sort-co...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== CHAPTERS =====
0:00 Intro
0:46 Quick Recap - What is UNICHAR Sort by Columns?
1:57 Case 1 - Problems with Explicit Filtering UNICHAR Sorted Columns
4:50 Case 2 - Problems with Advanced Filtering the Visual
5:50 Shoutouts & Outro
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[@GeertDelmulle]

Hey Chandeep,
Thanks for the quick update! :-)
Here are my 2 cents on the topic:
Region_Modified should only be used as a “label”-field in a dTable and not as a field that is used in calculations; for that they should use the Region field (unmodified). That’s how I would use it anyway.
That should avoid all those issues, IMO.

[@dilipinamdar5523]

Thank you!!!

[@matthiask4602]

great follow-up, thank you so much, cudos also to Reid

[@srikantrath7641]

Thanks for updates. Wanted to understand will it work for other apart from date column sorting approach

[@letiziabellavia2488]

Hello, what about sorting formatted measure as text showing positive and negative values? How UNICHAR can work in this case?

[@williamarthur4801]

Regardless of anything else I'd like to know how you found the code 8203? , also for introducing the
Characterfromnumber etc.

[@GoodlyChandeep]

random curiosity and time to waste 😂

[@williamarthur4801]

@@GoodlyChandeep LOL. Keep it up so we don't have to.

[@NicolaJelmorini]

Maybe it's better to add the repeated characters to the end of the text column. So there will be no issues with the usual filtering.