Forum Discussion
Table sorting in Power BI desktop
Hi,
Turns out that because I had another table in my data model that was using the same headers as this table, it was causing the conflict. I changed the table headers and it worked fine.
How I get around the same "null" values is by going into power query editor and then filtering those out, going back to DAX and then set the sort order before going into power query editor and removing the filter. It still keeps the same sort order then.
I didn't realise Power BI would consider a totally non-linked table to sort the current table but that was my issue and it is now resolved. Unfortunate that it took me almost an entire day to figure this out!
Hi.
Could there be a sneaky leading or trailing 'space' or other similar character on one of the rows in either of the two columns? Try to run it through a Trim function in Power Query first and see if it makes a difference,
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data
Hi Jonvoge,
I did think of that and tried that already. No such things which is why I am stumped and reached out here. I am completely bamboozled by this.
Does DAX Query View turn up anything?
EVALUATESUMMARIZE('Your Table', [Level 1], [Level 1 Order])If you only get each value once there for Level 1 Order it would seem to be a bug?
