Power BI

Completed

Should be able to sort the value for axis or legend when showing in chart

Vote (27)

Regis on 31 Dec 2014 11:52:40

Say when there are three distinct values in the field of an Axis, like 12/20, 12/21, 12/22, we should be able if need to sort them in asc or desc when showing in the chart. Currently, they come out in a random order

Comments (8)

Comments (8)

a760f0e1 fac2-4184-821a-c3acfba9a27b on 05 Jul 2020 22:21:20

RE: Should be able to sort the value for axis or legend when showing in chart

'+1 for this.

3647a308 cd7e-4615-b0cf-c16b76b12728 on 05 Jul 2020 22:20:01

RE: Should be able to sort the value for axis or legend when showing in chart

I have tried using the sort by column in the modeling section and it has no impact on the legend order. I created the sort by column specifically for the dimension column I am using for my chart. What is the trick?

52e20ec7 5f34-410e-9e78-a18e889df472 on 05 Jul 2020 22:17:08

RE: Should be able to sort the value for axis or legend when showing in chart

Rory is correct. You can sort using another field in your data set. Use Modeling -> Sort By Column. You might need to join this to a new table just for the purpose of sorting.

a74e63bd 01c0-4046-8de9-fab6e04bfbbc on 05 Jul 2020 22:04:02

RE: Should be able to sort the value for axis or legend when showing in chart

Sort order for legends and categories should be able to be derived from another field in your data set.

0278c812 9bf5-4c84-b7a4-ef9d68cc9103 on 05 Jul 2020 22:03:24

RE: Should be able to sort the value for axis or legend when showing in chart

Having updated to the July level this a big take away. It make the charts next to unreadable without being able to sort when the x-axis contains many string fields, e.g. Short State Names etc.

75ef863b f430-4c59-93d7-23b08a951a4c on 05 Jul 2020 22:01:56

RE: Should be able to sort the value for axis or legend when showing in chart

I would love this! Very interested, as we use month, weekday and hour in our axis tables. Unsorted is nonsensical for the reader.

53488c37 6753-4a9c-bdaf-be35e774ba24 on 05 Jul 2020 22:00:07

RE: Should be able to sort the value for axis or legend when showing in chart

'+1, need to be able to sort legend.

3ccfe15c fbae-4d77-bde5-e90fbd8e52ff on 05 Jul 2020 21:59:16

RE: Should be able to sort the value for axis or legend when showing in chart

It would be helpful to be able to sort a legend as well, currently, if we use text and want to sort it a specific way, there is not any ability I can find to specify exactly which order I want to show the legend. Makes it hard to show text values like bronze, silver, gold, and platinum in a specific sequence.