Forum Discussion
Custom Sort Order - Stacked bar chart
Hi, I would like to sort my data based on two parameters. I would like to sort the data by Client Names that have the most number of Project IDs associated with them as well as the highest % win ratio for these Clients (win/(win+lost)). How can i achieve this on a stacked bar chart? I've attached the sample dataset below. Thank you!!
| Client Name | Project ID | Status |
| Sample1 | 1 | Won |
| Sample2 | 2 | Lost |
| Sample2 | 3 | Pursuing |
| Sample2 | 4 | Won |
| Sample3 | 5 | Lost |
| Sample3 | 6 | Lost |
| Sample4 | 7 | Won |
| Sample5 | 8 | Lost |
| Sample6 | 9 | Won |
| Sample6 | 10 | Pursuing |
| Sample7 | 11 | Won |
| Sample7 | 12 | Won |
| Sample7 | 13 | Won |
| Sample8 | 14 | Lost |
2 Replies
Jairacha , if client is on the axis, then you can add a measure in the tooltip and use that for sorting.
Hi amitchandak , thanks so much for your suggesstion! Would you be able to guide me through what the DAX expression would look like for such a calculation (Clients with most number of Project IDs associated with them as well as the highest win%)? Appreciate the help!!
