Forum Discussion

gaspi's avatar
gaspi
Regular Visitor
8 years ago

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 “L...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

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's avatar
gaspi
Regular Visitor
8 years ago

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 

:-)