Sort clustered column chart and slicer

[Anonymous]

Good day , I know they are several questions about these but I just don´t find the solution.

How can I sort this grafic by the y axis insted of the legend:

Also , how can I sort this slicer by the numerical sequence , this is how it looks right now:

Thanks ,

[rubayatyasmin]

Hi, @Anonymous 

click on the three dots in top left corner of the viz and click sort by your y axis name. 

2. Create a column that contains the numeric values only. then from the data view, look for sort column by option then select the column that you want to sort by the newly created column.

I hope this helps. 

[Anonymous]

Hi, @rubayatyasmin , thanks for your answer.

1. The three dots are only showing me the option of sorting by legend :

2. Got it , will do it.

[rubayatyasmin]

check for your data type. if its in text format make it whole number then try again or refresh. Try new visual. see if that works. if the problem persists create a sort column like solution 2. 

this should do the trick