Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |