Forum Discussion
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
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.
3 Replies
Anonymous
what is custom sort?
if you need sort by other column value - try this technique https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
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.
Hi Anonymous ,
How about the result after you follow the suggestions mentioned in my original post?
Could you please provide more details or expected result about it If it doesn't meet your requirement?
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.
