How to avoid parameter drop down option on not getting sorted in alphabetical order

Question & Answer
, , , ,
1

{9854809F-4D9F-49A9-8FB7-FEBEE618F245}

In the image i have created a parameter control with (Day, week, month , quarterly and year)
but I need them in D,W,M,Q,Y.

instead they are getting sorted in alphabetical order.
How to get the dropdown view desired ( Day, Week, Month, Quarter, Year ) ?

2

Hi @azamnawa,

By default, QS sorts values in alphabetical order for controls and filters. While this may not be exactly what you’re looking for, you can use the following workaround:

  1. Day
  2. Week
  3. Month
  4. Quarter
  5. Year

I hope this helps!

Thanks,
Pradeep S

3

Hi @azamnawa,

Welcome to the QuickSight Community!

To achieve this, you’ll need to take a manual approach.

You have four parameter values, so assign spaces as follows:

  • 4 spaces for Day
  • 3 spaces for Week
  • 2 spaces for Month
  • 1 space for Quarter

Once you do this, QuickSight will accept it as a custom order and provide the desired results.

Please refer to the picture attached for a solution.

image
image1078×700 70.4 KB

Thanks & Regards
Biswajit Dash

4 Likes
4

Appreciate your help pradeep
But this would sometimes confuse stakeholders
they might think 1day data or so

The below solution helps me. thanks a lot

1 Like
5

Appreciate your help @Biswajit_1993

Your solution really helped me

with this i can easily switch to any period level easily and in same order of dropdown view.

Thanks a lot. :slight_smile:

1 Like