Forum Discussion

cuseman03's avatar
cuseman03
Helper I
1 year ago
Solved

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 sh...
  • v-priyankata's avatar
    v-priyankata
    1 year ago

    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.