Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
WBADAM03
Frequent Visitor

Column headers out of order

Hi All,

I feel like the biggest moron in the world, but I've been on this one problem for almost an hour with no resolution. 

I have a table with a plan_status column that is text
I have a table with a status_order column that is a whole number
The status order is a DAX column that looks up the string on plan_status and assigns it a numerical number ranging from 1 to 9

The idea is that I have a table with headers that look like this:

The problem is that the headers are out of order! Applied should be first, then canceled, then admitted, then enrolled. Their numerical values calculated in status_order should outline the position.

status sort is a whole number.

I can't seem to figure how how to make it start with 1 and then work it's way up to 9. I can only assume it's sorting the headers by alphabetical order instead of the numerical value.

WBADAM03_0-1714673021127.png

I can only "sort by" acad_plan and "EMPLID" in the visual.

Ironically, one of the graphs correctly orders the headers but I haven't been able to figure out why it works or how to make this table work.


WBADAM03_1-1714673148762.png

Any tips/advice greatly appreciated! 

2 ACCEPTED SOLUTIONS

Hey,

I tried that it and it said it had a circular reference (which I don't understand since all 3 columns are in one table).

I worked around this problem by doing [status order] &" - " & [plan status]" so it sorts the columns alphbetically by the status order, so it works.

View solution in original post

Hi @WBADAM03,

 

It's great that the workaround is working for you. In case you want to know more about circular dependency and see how to go around it, just go through the following post once and let me know if it's of any help to you.

 

https://community.fabric.microsoft.com/t5/Desktop/Sort-Values-from-Calculated-Column/m-p/3862774#M12...




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Regards,

Bipin Lala | Business Intelligence Developer



View solution in original post

3 REPLIES 3
Alex87
Solution Sage
Solution Sage

Hello,

Go to table view, select your column plan_status, select sort by column status order. Does it help?




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!




Hey,

I tried that it and it said it had a circular reference (which I don't understand since all 3 columns are in one table).

I worked around this problem by doing [status order] &" - " & [plan status]" so it sorts the columns alphbetically by the status order, so it works.

Hi @WBADAM03,

 

It's great that the workaround is working for you. In case you want to know more about circular dependency and see how to go around it, just go through the following post once and let me know if it's of any help to you.

 

https://community.fabric.microsoft.com/t5/Desktop/Sort-Values-from-Calculated-Column/m-p/3862774#M12...




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Regards,

Bipin Lala | Business Intelligence Developer



Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors