Forum Discussion
Dynamic legend on bar chart doesn't sort categories properly when switching between selections
Okay, so i have dynamic legend with three columns/categories (one is text, two of them are numbers, 0-10 and 1-16 respectively and they have their own tables). There's parameter on the slicer, so whi...
Hi kopytko95 ,
Based on your description, I can understand that you want to sort a bar chart with a fixed order of x and y axes. In Power bi, the initial sorting of the axes is usually numerical descending and alphabetical descending. If you change the data on an axis, it will be initialized. Also, you can only sort the bars according to one axis, otherwise the other axes will be affected.
You can refer to these two documents
Sort one column by another column in Power BI - Power BI | Microsoft Learn
Change how a chart is sorted in a report - Power BI | Microsoft Learn
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly