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 “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

Need Help

3 Replies

  • 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 

      :-)

  • cpaysinger's avatar
    cpaysinger
    Regular Visitor
    8 years ago

    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.