Sort a column chart by x axis data category

[Haider121]

I have data like this 

<10	10+	50+	75+	100+	Not at Customer	DateKey	InsertTimestamp
789	1303	458	242	98	2441	20170111	2017-01-11 10:07:11.620
742	1492	658	328	139	2560	20161228	2016-12-28 00:00:00.000
758	1509	666	348	190	2660	20161221	2016-12-21 00:00:00.000
766	1529	669	399	250	2760	20161214	2016-12-14 00:00:00.000
792	1725	690	400	360	2360	20161207	2016-12-07 00:00:00.000
800	1824	750	500	470	2260	20161130	2016-11-30 00:00:00.000
825	1700	890	600	580	2160	20161123	2016-11-23 00:00:00.000
852	1600	850	290	426	2460	20161117	2016-11-17 00:00:00.000
890	1505	700	333	400	2960	20161109	2016-11-09 00:00:00.000
642	1400	600	300	120	2550	20170104	2017-01-04 00:00:00.000

which plots toa BI chart like so

What I want to do is sort the bottom column out as <10 , 10 + 50 + 75 + and then 100 +, not at customer.

Since I have pivoted the data to get it to the table above I dont have the category now in one column for a sort order as is the norm, any ideas on how to do this? 

ie, Normally one would have something like this

 daysbanding    no of products                    sortorder

< 10                       71                                       1
10+                        702                                      2
50 +                       462

but to get the chart I want I need the data to be like the first table.

[v-shex-msft · Accepted solution]

Hi @Haider121,

If you use the live mode to connect, you can only group rank at service side.

If you use the import mode, you can refer to below link which about group ranking:

Raking within a group

Regards,

Xiaoxin Sheng

[Seth_C_Bauer]

@Haider121 It sounds like Grouping/binning might be your solution. Take a look here

[Haider121]

Sorry I forgot to say my data is coming froma SSAS tabular model so its not a dataset within powerBI that can be grouped or binned.

That option does not appear when selecting the columns for me.

[Anonymous]

@Haider121 do you work in the Channel Islands?

[Haider121]

no I work near manchester

[Anonymous]

Apologies...I thought you might have been an ex-work colleague with the surname Haider.

[Haider121]

np,lol, thats my forename

[Anonymous]

 I'm completely wrong on all counts then. haha.