topic Re: Unable to sort legend in line chart using disconnected table in DAX Commands and Tips

Unable to sort legend in line chart using disconnected table

SUMESHKUMAR22 — Fri, 28 Mar 2025 15:49:25 GMT

Hi Community,

In the attached pbix file, Im facing 2- problems mentioned in the respective pages.

In Problem-2 : Im trying to sort the legends using disconencted table but its not sorting as per my Dim Channel table - sort order column. [ Organic line on Top, then Search in middle & Display in bottom ]

Thanks in advance!

Re: Unable to sort legend in line chart using disconnected table

Jihwan_Kim — Sat, 29 Mar 2025 06:00:46 GMT

Hi,

I am not sure if I understood your question correctly, but please try to use Channel from Dim_Channels table.

Please check the below picture and the attached pbix file.

Re: Unable to sort legend in line chart using disconnected table

SUMESHKUMAR22 — Sat, 29 Mar 2025 06:33:41 GMT

Hi Jihwan_Kim ,

Sill it wont work. Expected output should be like below (Organic line on top, then search then Display), it should follow sort order, but this happens when I use stack area chart (which I dont want to use otherwsie my avg line will get removed).

Expected:

Thanks!

Re: Unable to sort legend in line chart using disconnected table

Hakuna_matata — Sat, 29 Mar 2025 12:29:10 GMT

Hi SUMESHKUMAR22 ,

We may, apply the column sort, remove the channel from the legends, and reapply the channel to legend again, this will update the order for your legends. Hope it help!
If this solved your problem, please accept it as a solution!! ^_^

Re: Unable to sort legend in line chart using disconnected table

SUMESHKUMAR22 — Sat, 29 Mar 2025 13:02:02 GMT

Hi Hakuna_matata ,

The file is already following that technique but the sort is not happening in line chart 😞
Im expecting the output of line chart like below, where the Organic channel on Top, then search & display.

Thanks!

Re: Unable to sort legend in line chart using disconnected table

Jihwan_Kim — Sat, 29 Mar 2025 13:41:12 GMT

Hi,

Please check the below picture and the attached pbix file.

Re: Unable to sort legend in line chart using disconnected table

SUMESHKUMAR22 — Sat, 29 Mar 2025 14:26:58 GMT

Hi ,

Its the same as the original file. No change. The Green line (Organic) should be on Top then Search & display. Refer my above screenshot please.

Thanks!

Re: Unable to sort legend in line chart using disconnected table

SUMESHKUMAR22 — Sat, 29 Mar 2025 14:28:01 GMT

HI Team,

Please dont consider this as solution. Its yet to be resolved.

Thanks!

Re: Unable to sort legend in line chart using disconnected table

Hakuna_matata — Sat, 29 Mar 2025 14:41:23 GMT

Hello the order of line is dependent on data values, as Jihwan suggested we can use ascending or descending order. For legends try removing the legend from visual and re-add legend channel. Hope it helps!

Re: Unable to sort legend in line chart using disconnected table

SUMESHKUMAR22 — Sat, 29 Mar 2025 14:52:01 GMT

Hakuna_matata ,

Thanks for Checking in. The issue still persists after removing the legends. If you could look into the file, its performing the same approach but unable to sort by legends (nor asc/desc).

Thanks!