Forum Discussion

philjohn's avatar
philjohn
Frequent Visitor
3 years ago
Solved

Custom Sort Function for X-Axis not working

Wanted graph in time sense, daily, weekly, etc etc annually

 

 

I created the table and placed the sort by column as index and added that field to the visual - sorted the visual and still... not in order?

 

 

 

 

Im at a loss at what to do

 

 

 

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi philjohn ,

     

    According to your description, here are my steps you can follow as a solution.

    (1) This is my test data.  

    (2) Select the Frequency column to sort by the Index column.

    (3) Then the result is as follows. Be careful not to sort the visuals again.

    If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi philjohn ,

     

    According to your description, here are my steps you can follow as a solution.

    (1) This is my test data.  

    (2) Select the Frequency column to sort by the Index column.

    (3) Then the result is as follows. Be careful not to sort the visuals again.

    If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.