Hi Chen Lei,
thank you for your patience. I have now been able to get access to the bridge chart Component and can finally answer your questions.
You can change the sorting by using a modified version of the CASE WHEN statement you’re already using for your dimension. Replace the category names with numbers specifying the order in which you want the columns to appear.
In your very first post in this thread you wrote the code for your dimension. So if for example you wanted the columns to appear in the order (from left to right): “Others”, “Late SL” and “Early SL”.
So instead of
CASE WHEN “DELIVERIES”.“RGK_DRRA”>0 AND “DELIVERIES”.“RGK_DRRC”>0 THEN ‘Late SL’
WHEN “DELIVERIES”.“RGK_DRRA”<-3 AND “DELIVERIES”.“RGK_DRRC”<-3 THEN ‘Early SL’
ELSE ‘Others’ END
In sorting you would write:
CASE WHEN “DELIVERIES”.“RGK_DRRA”>0 AND “DELIVERIES”.“RGK_DRRC”>0 THEN 2
WHEN “DELIVERIES”.“RGK_DRRA”<-3 AND “DELIVERIES”.“RGK_DRRC”<-3 THEN 3
ELSE 1 END
You can change the colors of the columns by writing different Hex color codes in the box next to the word Colors. Please note it’s important that the total number of color codes listed in the box must match the number of columns, otherwise all the columns will have the same columns. I suspect that as you changed the dimension to include 5 categories instead of the original 3 the color setting didn’t update to reflect this resulting in all the columns being black, just add two more color codes (separated with a semi colon) and the problem should go away.
I hope this answers your question.