cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

sorting in Line and stacked column chart

Hi,

I have Power BI Desktop connected to SSAS live.
When I display dimension data through  “Table” visualisation, sorting is OK - as set in OLAP dimension.
When I display dimension data through “Line and stacked column chart” (dimension is on “Shared axis”) sorting, witch is set in OLAP dimension is ignored. Is there option how to set sorting "by setting in OLAP" ?

thanks

3 REPLIES 3
Highlighted
Resident Rockstar
Resident Rockstar

Re: sorting in Line and stacked column chart

Hi @gaspi

 

Could you find the option  sort by setting in OLAP in the more options ?

 Untit2led.png

 

If you need additional help please share some data sample which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: sorting in Line and stacked column chart

Hi Cherry,

Sorting in „More options“ cannot be used, because it is alphabetical sorting but

sorting on dimension in OLAP cube isnt alphabetical.

I will give example There are my data in grid visual:

 

img1.jpg

 

Sorting on visual - as you can see -  is not set. Data in grid visual are sorted correctly - as is it

set on dimension in OLAP Cube (the order on dimension is not alphabetical).

Now look at the same data in “Line and stacked column chart” (Sorting in „More options“ isnt used too):

 

img2.jpg

 

So problem is that this visual (“Line and stacked column chart”) doesnt respect sorting settings on dimension in cube.

thanks 

🙂

Highlighted
Regular Visitor

Help Please

Hi.

 

I am working on a simple line graph in power BI. I have pulled in my data, sumed it up, but when I go to graph it the x axis is out of order. For example I have weeks of the year going from 1 to 52. In my data view the data is sorted from this week of the year column from 1 to 52 sequentially, but on the graph the x axis starts with 1 then jumps to 10 then 24 and then 6 etc. It is not in order. I have tried to sort the column but the numbers never align. Any ideas, bene stuck on this for a while now.

 

 

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

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