Forum Discussion

cuseman03's avatar
cuseman03
Icon for Helper I rankHelper 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...
DAX
sort
time
  • Anonymous's avatar
    Anonymous
    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        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.