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

Rob83's avatar
Rob83
Frequent Visitor
9 years ago

I have a problem with sort by column option. I get a warning that  The column can't be sorted by a column that is already sorted directly or indirectly, by this column. This is because I have a sort my outcome into 6 buckets (0-7 days, 8-30 day, ....) So to give this a rank I uses the IF formula. But then the sort by column doesn't work is there an alternative do reach the same?