do you have any sample working dashboard which I can check. am not sure how to do manual sort in dashboard.
Let me explain here.
1.Meausre % -> if parameter_type = 'X' then Measure1 elseif parameter_type ='Y' then Measure2 end
2. Dimension -> Company
I am using bar chart to show highest % to lowest % by company .
when I am change the parameter type from X to Y or Y to X then the sorting is not working.
Sample 2: After swap the measure.
I think I may have an idea. ProviderName is being sorted in Ascending Order, yet the values in the first graph appear to be in Descending Order. This leads me to believe that the issue is not in your sorting, but in whatever Table Calculation you have placed on top of Method %. Any chance you could post a mock-up or .twbx?
You can sort by the result of a table calc by placing the calc as a Discrete (blue) pill on the Rows shelf.
In the attached, I also unchecked the option for Show Header, and adjusted the level of the Row border format.
table calc sort.twbx.zip 11.4 KB
Thanks Joe , it works for me.