Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Haider121
Frequent Visitor

Sort a column chart by x axis data category

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

stuff.jpg

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.

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

8 REPLIES 8
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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
Not applicable

@Haider121 do you work in the Channel Islands?

no I work near manchester

Anonymous
Not applicable

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

np,lol, thats my forename

Anonymous
Not applicable

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.