Forum Discussion
Sort two columns on the same one column
I would like to create a bar chart with these columns: Category, Subcategory, Quantity The x axis will be both Category and Subcategory. The y axis will be Quantity. I want to sort Catego...
I found the solution on YouTube! Link: https://youtu.be/RDXvpE3V5m0?si=NA5s7BVR5Xu9yy6g
Hi again,
Here is an advanced version of this approach which should work in more complicated scenarios.
The idea is to create a measure which generates a sorting order value consisting of two parts: the whole part is responsible for sorting categories, the decimal part - for sorting subcategories.
Best Regards,
Alexander
Hi barritown,
Let me try this and update here again soon. Thank you
Hi! Sorry for the incredibly late reply. It doesn't quite work somehow. But good news, i found a video online that solves my problem. Thank you so much for your time !!