Forum Discussion

mw's avatar
mw
Regular Visitor
9 years ago
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 does...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

mw's avatar
mw
Regular Visitor
9 years ago

Thanks a lot, 

Martin