cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Sorting (manual sorting of dimensions)

Hi all,

 

I am currently using an OLAP cube connection and I want to sort my bar charts e.g. in a custom way - meaning: NOT alphabatically, highest to lowest and vice versa.

 

Still working with the cube connection, in excel I would just convert my pivot-table or whatever to formulas and then change the order of dimensions as I wish by a "drag-and-drop" approach (hope this makes sense).

 

Does anyone know a work-around to this issue? It is not possible to change the data connection atm., but it's something we are planning to do down the road.

 

Thx in advance.


Best regards,

Marco

4 REPLIES 4
Highlighted

Re: Sorting (manual sorting of dimensions)

Bar charts should allow you to change the sorting from lowest to highest or vice versa using the sort options under the ... button. Unless (???) they don't work for OLAP cubes? But for drag and drop - I agree, it would be nice to just sort things that way too sometimes.

 

Scott

Highlighted
Helper I
Helper I

Re: Sorting (manual sorting of dimensions)

Hi Scott,

 

The point is that I DON'T want to sort by values, that option works perfectly fine with OLAP cubes.

 

I want to sort based on a "logic" that makes sense within this company.

I am using a horizontal bar chart to show sales from multiple companies - I want to sort the companies as I wish; company A should be at the top, no matter sales quantity or whatever.

 

Does it make sense?

Highlighted

Re: Sorting (manual sorting of dimensions)

Yep, sure does. Is it possible to smash the data set up with a simple excel worksheet that lists the companies and has a sort order column for them? If it does, you could then use the sort order column as the default sort for the company dimension?

 

Thx,

Scott

Highlighted
Helper I
Helper I

Re: Sorting (manual sorting of dimensions)

I will look into it with our BI architect and come back!

 

Thx!

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors