Custom Sort of Table and X axis not working powerbi

[Suzie_Suze_Sue1]

Hi All,

Pulling my hair out with this one. I doing a demographic report on certain questions we ask our customers

I have a table with fields, using the slicer on questions of which there are about 40

Question	Sort	Age	Positivity	Benchmark
01. How do you rate your item?	1	Under 21	90.17	90.98
01. How do you rate your item?	2	21 to 25	84.06	90.63
01. How do you rate your item?	3	26 to 30	81.94	90.08
01. How do you rate your item?	4	31- 49	81.91	92.94
01. How do you rate your item?	5	50+	87.74	91.13
02. Was your item value for money?	1	Under 21	80.22	79.11
02. Was your item value for money?	2	21 to 25	76.09	82.06
02. Was your item value for money?	3	26 to 30	76.39	84.14
02. Was your item value for money?	4	31- 49	82.45	89.81
02. Was your item value for money?	5	50+	79.87	80.91
03. Would you recommend us?	1	Under 21	77.46	83.91
03. Would you recommend us?	2	21 to 25	74.45	83.01
03. Would you recommend us?	3	26 to 30	68.06	84.5
03. Would you recommend us?	4	31- 49	80.85	90.04
03. Would you recommend us?	5	50+	77.09	84.56

           I am creating a line and stacked column chart, but am struggling to get the X axis in the correct sort order. I have sorted in table view by column 'Sort' so that it is in order 1-5, and even created a seperate table with just the age and sort, following on from google search on how to do this. I am also using for a table, and having the same issue.

Any ideas on how to resolve this please

Thank you 🙂

[Suzie_Suze_Sue1 · Accepted solution]

Hoping this works

TestForupload.pbix

[Bibiano_Geraldo]

Hi @Suzie_Suze_Sue1 ,

Select your column chart, and click on 3 dots that appear on the visual, go to sort axis, and select the value that it is in your x axis as shown bellow:

[Suzie_Suze_Sue1]

No had already tried this and didn't work 😞

[Bibiano_Geraldo]

Hi @Suzie_Suze_Sue1 
Can you share a sample file with no sensitive information, just to se closer what is happening?

[Suzie_Suze_Sue1]

Yes, but not sure where I upload file to ?

[Bibiano_Geraldo]

You can upload to the cloud, like onedrive or other, and share the link for download here in comments.

[Suzie_Suze_Sue1 · Accepted solution]

Hoping this works

TestForupload.pbix

[Bibiano_Geraldo · Accepted solution]

I think you want sort like this:

If so, please follow me:

1- go to table view, select the age column and go to sort by column and sort by sort column as shown bellow:

Now go to report view, select your column chart and sort by age in ascendig order:

[danextian]

Hi @Suzie_Suze_Sue1 

You might be sorting your viz by the measures and not by the category. You can see in the screenshot below that the categories are sorted according to the sort column.

[Suzie_Suze_Sue1]

No that doesn't work either.

The question is a slicer, so this is what I am getting