topic Re: Sort the columns according to their name. in DAX Commands and Tips

Sort the columns according to their name.

amgelain — Fri, 10 Nov 2023 01:25:54 GMT

Hello dear!

I need to order the columns of the chart according to the description of each one.
For example: the first column "Excellent", the second column "Great", the third "Good" and the fourth column "Terrible". I couldn't figure out a way other than the constants in the axis sort options.

Thank you very much in advance if anyone can help.

Re: Sort the columns according to their name.

Jihwan_Kim — Fri, 10 Nov 2023 03:12:54 GMT

Hi,

I am not sure how your datamodel looks like, but one of ways to solve this is to have sort-order-column for the column that you want to use in the visualization. And then, sort it by the sort-order-column.
I hope the below link from Microsoft helps.

Change how a chart is sorted in a report - Power BI | Microsoft Learn

Re: Sort the columns according to their name.

FreemanZ — Fri, 10 Nov 2023 03:36:37 GMT

hi amgelain ,

a column could be sorted by other column.

how: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-desktop

You would need a helper column. supposing you have a data table like:

Grade	Count
Excellent	10
Great	20
Good	50
Terrible	10

try to

1) create a dimensional grade table like:

Grade	GradeID
Excellent	4
Great	3
Good	2
Terrible	1

2) related data table and grade table

3) sort the grade[grade] column by grade[gradeID]

4) plot a bar chart with grade[grade] with data[Count]. The axis shall be sorted as you wish, like: