Forum Discussion

mw's avatar
mw
Regular Visitor
10 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

mw's avatar
mw
Regular Visitor
10 years ago

Thank you Lydia

 

The Chart looks now like that:

 

 

 

I'd like to have several curvers for the percentiles for the several CHF Swap Rates (x-axis). That is fine so far. But the Legend of the x-axis should ordered by the duration (1W = 1Week, 1M = 1 Month, 2M = 2 Month....1Y = 1 Year...up to 30 Y). 

 

For this purpose I tried to add a column "SortBy" and used "Modeling", "Sort by Column". I didn't get an error Message but it didn't work as you can see on the picture of the chart. 

 

Thanks Martin

 

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