Forum Discussion
Custom Sort by x-axis legend
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
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
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.