Forum Discussion
sorting on a joined table custom sort
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.
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.
-
7 Replies
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.
unfortunately, none of those work
If you could share a link (OneDrive, etc.) to a sample pbix illustrating the issue, I'll take a look.
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.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.
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.
-
