Custom Sort by x-axis legend

[mw]

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.

[v-yuezhe-msft]

Hi @mw,

Could you please describe more details about your scenario? We need to know which field you put in legend and the exact error message you get when using “Sort by Column” option. In addition, if you want to sort the column ‘Perzentil’ by ‘SortBy’, you need to make sure that the values in the Perzentil column map m:1 with the SortBy column.

Thanks,
Lydia Zhang

[mw]

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

[v-yuezhe-msft · Accepted solution]

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]

I tried using this approach for a similar problem I'm facing. I have a table with two columns:

Column 1 = Modules

Column 2 - Hrs spent

Just that module list comprises of 1, 2, 3, 4, 5a, 5b, 5c, 6, General, Another project, etc. Basically, they're not all numeric, so I couldn't sort them as is. I created a secondary table called "Sorter table" that has two columns:

Column 1 = Module

Column 2 = Sort ID

and used this new table to sort the module alphanumeric entries as I wanted them.

Then I went to the relationship view and linked the "Modules" field (from Table 1) to the "Module" field (from Table 2).

I still don't get how to use this new Sort ID column to sort my modules on the X-axis.

Any help appreciated.

[Rob83]

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?

[mw]

Thanks a lot, 

Martin