Forum Discussion
gaspi
8 years agoRegular 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 “L...
cpaysinger
8 years agoRegular Visitor
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.