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?
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]