Forum Discussion

m-m-esh's avatar
m-m-esh
New Member
2 years ago

Combining chart bars with identical values, but in different order

I'm getting multiple data bars generated on my chart that have the exact same multi-select values, but are in a different order (see image)

How do I make the bar generation order-agnostic?

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Add a calculated column that splits the text, sorts the elements alphabetically and then recombines them.

     

    Please provide sample data in usable format (not as a screenshot) if you like more help.