Forum Discussion
Solved
Custom Sort by x-axis legend
How can I add a custom Sort in a line chart with the legend
| 1W | 1M | 2M | 3M | 6M | 1Y | 2Y |
and so on...
I tried to add a sort column and used "Modeling", "Sort by Column" but it doesn't work. Does anyone have an idea how to solve the problem? Many thanks.
Hi mw,
In your scenario, please create a new table to sort CHF Swap Rates with desired order as follows, then merge this new query to you original query and retain the order column.
After that, please click the CHF Swap Rates column in the Field Pane, then select the order column after clicking “Sort By Column” under Modeling ribbon. This way, you are able to achieve your requirement. For more details, you can review the example in the attached PBIX file.
Thanks,
Lydia Zhang
