Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 ...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    2 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    This worked for me. Thank you!!