Stacked bar chart - able to sort by just one of the results?

[bryanc78]

I have a data set that shows if an employee passed or failed a test.  I would like to be able to show a stacked chart that shows how many times they failed and how many times they passed, which is easy enough, but I would like to be able to sort it by the fails.  

The default sorting options is only by employee or total number of tests.  Any way sort by fails?

[v-lili6-msft · Accepted solution]

hi, @bryanc78 

You could try this way:

Don't drag "result type" field into Legend.

Then create two measure:

1. times of failed= Calculate( CountA( [employee] ),  "result type"="failed")

2. times of passed= Calculate( CountA( [employee] ),  "result type"="passed")

Then drag the two measure into Value and then sort by [times of failed]

Best Regards,

Lin