topic Re: Colors and Legend Ordering in App Development

Colors and Legend Ordering

AndrewMcIlwrick — Sat, 16 Nov 2024 04:09:20 GMT

As per screenshot, by using custom colours for a chart (by creating a master dimension and assigning colours to each dimension) messes with the ordering of the Key I want it to be in a specific order. I use the below sorting expression however it does not affect the key.

Match([Coverage Group (All)],'Short','Med','Long','Very Long','Dead Stock','NYA','Cat 0')

Re: Colors and Legend Ordering

y_grynechko — Fri, 15 Nov 2019 20:47:09 GMT

Hey,

Add dual value to the dimension or add additional dimension like this in the load script:

if([Coverage Group (All)], ='Short', 1,

if([Coverage Group (All)], ='Med', 2)) as Sort (add more ifs)

After doing this you can use the Sort field to Sort the bar chart.

Re: Colors and Legend Ordering

ksharpes — Wed, 20 Nov 2019 10:59:19 GMT

Hello,

This still does not affect the Legend sorting unfortunately.