Forum Discussion
Power BI Custom Visuals' Community
I have 2 issues when trying to sort an axis in Charticulator.
1) It does not properly sort whole numbers. It improperly sorts based on the first digit. For example, it will produce this sort order: 1, 15, 3, 35, 5, 6, 7, 75, 8, 85, 9. It will only resolve when I change my field format to decimal type.
2) When I sort it does not dynamically sort. For example, I sort by numeric value and it produces the correct sort for the year that is selected when I'm editing the visual. However, if a user makes any changes to slicers, the sort order remains sorted on the values that appeared when the edits were made. For example, if attribute 1 is 3.25 and attribute 2 is 4.25 in year 2020 when the sort was created, the axis will always keep attribute 1 at the top, even if it's value has decreased making it the lowest number in another selected year.
The link to my PBI report is here.
I am also experiencing the issue with dynamic sorting. When I sort, it only applies to the filter currently selected. I am also having another issue related to sorting. I am using a data axis that should only appear on the last value (at the bottom of the chart). When I try to change the field that determines the order of the chart (I want it ordered by date), the data axis still appears on the original last value (alphabetically). I am not sure how to fix this, so if anyone has advice, please let me know!