Forum Discussion
Solved
Sort stacked column chart by two criteria
Hello, there is some way to sort the following graph by 'quality of care' and by 'quantity of surveys', I see that it only allows me to sort by one or the other.
Thank you
You can use a measure like this and put it in the tooltips for your visual and sort by it. This converts both measures to text and concatenates them. The FORMAT is needed to get the same # of characters for both measures as text.
ForSort = var M1padded = FORMAT([M1], "000")var M2padded = FORMAT([M2], "000")return M1padded & M2paddedPat
1 Reply
You can use a measure like this and put it in the tooltips for your visual and sort by it. This converts both measures to text and concatenates them. The FORMAT is needed to get the same # of characters for both measures as text.
ForSort = var M1padded = FORMAT([M1], "000")var M2padded = FORMAT([M2], "000")return M1padded & M2paddedPat