Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sort graph based off personal preference

Hello all,   I have a bar graph I want to sort based off my personal preference not desc or asc   is this possible? here is my sample file with the graph I want to do a custom sort on pbix
Need Help
Show and Tell
Tips and Tricks
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi Anonymous ,

     

    There are two ways to sort that you can refer.

     

    1. The first way is sorted by existed column, such as name or value.

     

     

    2. The second way is to create a new dim table that contains the column that you want to sort, and add a numeric column to sort.

    By the way, we need to create a relationship between two tables.

     

     

     

    Then we can use the Table(2)’s name to show the data, and sort by column [Sort].

     

     

    If it doesn’t meet your requirement, could you please share the pbix again? Because we don’t have a permission to open it.

    You can also upload your files to OneDrive For Business and share the link here.

     

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ zhenbw

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