Bar Plot | Constant fixed order and display of the legend

[TinaHensel]

Hello together,

I am currently facing the following issue: 

I have a barplot with two dimensions:

• month
• status (used for colour representation)

And I have a measure "sum(ticket_id)". In the barplot, The barplot depicts the number of tickets per month depending on the status. The legend covers the different status colours.

Now I would like the legend to always be displayed in the same order, regardless of whether I have values for a status in a month or not.

To do this, I use the following sorting formula:

Pick(wildmatch(status,'registered','released','in progress','Introduction'),1,2,3,4)

Unfortunately, if I have a month in which no tickets with the status "released" appear, the order changes to: registered, in progress, introduction, released.

How can i fix this?

Thank you!

Best regards
Tina

[MarcoWedel]

Can you please post a small example application to test with?

thanks

Marco