Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
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.
Hello,
This still does not affect the Legend sorting unfortunately.