topic Re: sorting on a joined table custom sort in DAX Commands and Tips

sorting on a joined table custom sort

cuseman03 — Mon, 07 Apr 2025 14:38:12 GMT

Hi. I created a custom sort table and joined it to my values table so that I could sort time, on an X axis, alphabetically. For some reason, it starts out sequentially but stops after 8am. This should be relatively simply as I have a table with a custom sort, it's joined on a 1:M, but for some reason, it's not applying it. I have the custom sort field in the 'tooltips' field.

Re: sorting on a joined table custom sort

DataInsights — Mon, 07 Apr 2025 18:02:19 GMT

cuseman03,

In Table view, try sorting StartTimeRange by SortOrder (instructions below):

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

In the visual, use TimeSort[StartTimeRange] in the X axis.

Re: sorting on a joined table custom sort

cuseman03 — Tue, 08 Apr 2025 14:01:48 GMT

unfortunately, none of those work

Re: sorting on a joined table custom sort

DataInsights — Tue, 08 Apr 2025 15:56:29 GMT

cuseman03,

If you could share a link (OneDrive, etc.) to a sample pbix illustrating the issue, I'll take a look.

Re: sorting on a joined table custom sort

Anonymous — Mon, 09 Jun 2025 07:06:51 GMT

Hi cuseman03

Thank you for using Microsoft Community Forum.

Thanks DataInsights for your inputs. cuseman03 please share sample data or PBIX file, we will try to provide a solution.
Thanks.

Re: sorting on a joined table custom sort

Anonymous — Mon, 09 Jun 2025 07:20:24 GMT

Hi cuseman03

Thank you for using Microsoft Community Forum. provided some steps as per your quetion, if still your facing the problem,please share sample data or PBIX file.

Check that the relationship between TimeSort and SalesData is set up correctly (should be active and properly joined).
In Data View, click on the X-axis field in SalesData. Then, from the top menu, pick Sort By Column and choose the sort order column from TimeSort.
Make sure you’re not using the sort order column in the Tooltips—sorting works through the Sort By Column setting, not the Tooltips.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

Re: sorting on a joined table custom sort

Anonymous — Thu, 12 Jun 2025 09:28:48 GMT

Hi cuseman03
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

Re: sorting on a joined table custom sort

Anonymous — Mon, 16 Jun 2025 04:58:32 GMT

Hi cuseman03
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.