Forum Discussion
Sort by Parameter Measure (custom sorting)
I've been trying to custom sort the parameter I created for the dashboard but could not find a way to do so. Basically I need the viz to sort by: If "Age Group" is selected, custom sort it to show ...
Anonymous , Make sure for all those columns, you create a sort column and mark that as a sort column. You can create sort column using the same column in power query and then mark it sort column in data view.
If you create a sort column, to avoid circular dependency you need do like
Gender 1 = [Gender]
Gender Sort = if([Gender] = "Female",1, 2)
Then Mark Gender Sort as a sort column for Gender 1. and use Gender 1 in Visual
How to Create Sort Columns and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Ashish_Mathur
Super User
Super UserHi,
Share the download link of the PBI file with the Age Group column and visuals already created.