0

I have some data coming from a SQL Server query and the table looks as shown in the next figure:

enter image description here

If I display this in an Excel chart, it looks like the following picture: enter image description here

As it can be noticed, in Excel the chart displays the data according to the order they have in the table. When I tried to show this data in a Power BI line chart, it looks like the following picture: enter image description here

Because the data is sorted by the occupancy values.

I do not want the data sorted as Power BI does. I want the data in the same way they are in the table. Any ideas about how can I do to disable the sorting axis option?

Superman
  • 221
  • 2
  • 11
Dorian Oria
  • 119
  • 10

1 Answers1

0

This should be rather simple.

Just click on the field that is currently used for the sorting, once you click it, the sort goes away completely.

See demo:

Sort actived:

Sort Active

Sort deactivated (clicking on Count of Status):

Sort deactivated

Vojtěch Šíma
  • 86
  • 4