order by field not respecting power bi order by column

[ruthpozuelo]

Hi ,
I am testing the order by column where i try to order an x axis by month name:
If i use the month column, the default order is alphabetical order.

even though I have already specified in power bi that month name column should be ordered by month number.

The only way to make the order column work is to sort manually in charticulator. Is this behaviour expected?

[bongshin]

This change was made to address the issue #704. Charticulator automatically order the axis based on the data value when you assign a data column to the axis. You can use the order passed from Power BI by resetting the order (i.e., clicking on the Reset button). That said, we found issues with using this feature with a different column and we are working on them.

[ruthpozuelo]

Are you saying that if I order the month column in power bi charticulator will respect it? Because it didn’t do it for me?

[bongshin]

Yes, the "Reset" is supposed to respect to the original order in the data, which is determined by Power BI in this case (i.e., with the Charticulator visual): you can check it from the data table by clicking the “…” button from the Dataset Panel. Note that you can produce a semantically confusing outcome. For instance, in the example below, I did reset the order (with the Month assigned to the "Order by" field) while Power BI sort the data by the Steps column.

[ruthpozuelo]

Interesting, I need to test that again, because it didn’t do it for me. I will test it again and close the issue if it is doing it , otherwise I will share my file.
Thanks for the explanation!

[ruthpozuelo]

I tested it again and i still can not get sorted properly, so I wonder if maybe we are talking about different sortings?

So the sorting I mean, is not the visual sorting but the column sorting. In the case below the column Month name is being sorted by column number and that is respected when sorting the visual ascending or descending.

Attach my test file
Northwind Power BI final report-2021.pbix.txt

[bongshin]

[AdoremCeline]

@ruthpozuelo I always add an "order" colum in my base table to order fiels the way I want, even with month. I was fed up to struggle with the order tool ...

[ruthpozuelo]

I tried again and if I reset the order as @bongshin suggests (I have to do it twice that was my issue), it sorts properly now, so I will close the issue.
For anyone having issues, you might need to reset more than one time. Resetting once and then trying to sort in power bi will not do it.

[AdoremCeline]

👍