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
