sorting in Line and stacked column chart

[gaspi]

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

[cpaysinger]

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.

[v-piga-msft]

Hi @gaspi，

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

 

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

[gaspi]

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:

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):

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

thanks 

🙂