Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi All
Mr Amit have try to help on below post :-
https://community.powerbi.com/t5/Desktop/GL-CODE-Sorting-get-error/m-p/1600958#M648119
I try to create a very simple PBI file to check will it come out error msg ? below is my data set :-
below is the error msg :-
i am using Dec 2020 version.
Solved! Go to Solution.
@Anonymous
Please see two workarounds in the attachment. hopt this is helpful.
Proud to be a Super User!
Hi Ryan
You are very smart.
Thank
Paul
@Anonymous , GL_CODE_SORt is create on GL_CODE (groups) , it will not work .
Do this a new column GL_CODE (groups)1
GL_CODE (groups) 1 = [GL_CODE (groups)]
Sort this on GL_CODE_SORT and use in viusal
Refer my video I dicussed this : https://www.youtube.com/watch?v=KK1zu4MBb-c
Hi Amit
Can you pls send the PBI file , so that i can understand what you mean.
Paul
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.