Forum Discussion
Line chart re-orders sales period
It should take in ryt order but there is an other way.
Click on Enter data and create a new table with these values:
Join this ID field with Period column from your table.
Now, use ID field in the axis and
If it is sorted then you are good to go, else click on the ID field and then Sort by ID.
Let me know if this works.
Super UserHi Rachelbramos ,
Click on your line chart --> On the right under Visualisation Tab you will see Period column is moved to x-axis area. Check there and see if it is summarised or not. It should not be summarised.
Also under format options, try making your x-axis as Categorical and see if this fixes the issue.
Also I tried a similar scenario at my end and it works for me. See my Index column is sorted in ascending order:
If you still have issues try sharing your pbix file by removing any sensitive information.
Thanks,
Pragati
It actually doesn't even let me choose "continuous". If I try to click it, it defaults it back to "categorical". So I guess that's not the issue. It's for sure not summarized. Let me see if I can make a shareable version of the data so I'm not accidentally sharing company secrets 😉
Stay tuned...
Thanks again!