Forum Discussion
Ordering Yields on a line graph
Hi tnolte,
According to your description, I create sample data to reproduce the scenario. You have the Index Ref column already in your desired sort order from the screenshot, now select the column Tenor and Curve and click Modeling -> Sort by Column as showing picture below.
Then, create Line Chart visual and the Tenor and Curve on the axis will be sorted according to the value of the Index Ref column.
Here is my test pbix file link: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ERLX2CJ6RxdEoew9fkFjc9gBlFmcB5mGKpF4P9sBQ4fhVQ?e=5p2MGc
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi tnolte,
According to your description, I create sample data to reproduce the scenario. You have the Index Ref column already in your desired sort order from the screenshot, now select the column Tenor and Curve and click Modeling -> Sort by Column as showing picture below.
Then, create Line Chart visual and the Tenor and Curve on the axis will be sorted according to the value of the Index Ref column.
Here is my test pbix file link: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ERLX2CJ6RxdEoew9fkFjc9gBlFmcB5mGKpF4P9sBQ4fhVQ?e=5p2MGc
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This works perfectly. Thank you. It appears ordering by the column BEFORE creating the graph is the way to do it. I had no idea.
