sorting on a joined table custom sort

[cuseman03]

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.

[v-priyankata]

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.

[v-priyankata · Accepted solution]

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.

[v-priyankata]

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.

[v-priyankata]

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.

[cuseman03]

unfortunately,  none of those work

[DataInsights]

@cuseman03,

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

[DataInsights]

@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.