Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hi All
I have create a sort field = GL_CODE_Sort which is working fine , it return 1 to 5 :-
When i try to make use GL_CODE_Sort field act as sort column , i get below error when i click on the red box below image :-
Error msg pop up :-
Paul
Hi Amit
Thank you for your sharing. Yes i refer to GL Tab , but are sorting on the below Table ?
I try to sort again i get error msg. cannot go ahead.
My sorting i refer to make use of GL_CODE_SORT field as column sort.
Paul
@Anonymous , I am able to sort second table too.
In File menu open About, and check the version. Is it that you are upgrated to Jan 2021 and there is an issue.
I am on Dec 2020 release
Hi Amit
My version is Dec 2020 , see the below image :-
When i open the file you share with me , i notice that the table arrangement sequences still wrong , Are you able to make the PNL arrange in following sequestion :-
REV
COGS
OTHER
EXP
Hi All
Above link is my sample data file for PBI
Paul
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 58 | |
| 53 | |
| 42 | |
| 30 | |
| 24 |