Is it possible to display an ordered view of COUNT?

I was able to create a bar chart view by adapting the formula from a post here titled ("Count and group with a ref"), and I got this view (image below). What I want is to display the COUNT in ascending (or descending) order. How do I do that? 

The adapted formula is:

COUNT(
SELECT(enrollment[enrollment_id], AND(
[status] = "Completed", 
[mentor_id] = [_ThisRow].[mentor_id]
))
)

'enrollment' is the parent table; 'mentor_id' Ref's the 'mentor' table:

Screen Shot 2022-10-30 at 2.36.08 PM.png

Solved Solved
0 1 54
1 ACCEPTED SOLUTION

You can sort by aggregate values with the in-preview charting feature, but I don't believe it's possible with the base charting functionality.

View solution in original post

1 REPLY 1

You can sort by aggregate values with the in-preview charting feature, but I don't believe it's possible with the base charting functionality.

Top Labels in this Space