Sort Field Parameter

[Anonymous]

Hello everyone,

I have a parameter that is like below.

This is the DAX for my field parameter.

time_field = {

("hour", NAMEOF('mvpmonitoring'[update_time_hour_ts]), 0, "etl_update_time"),

("month", NAMEOF('mvpmonitoring'[update_time_Year-Month]), 0, "etl_update_time"),

("day", NAMEOF('mvpmonitoring'[update_time_Year-Month-Day]), 0, "etl_update_time"),

("hour", NAMEOF('mvpmonitoring'[insert_time_hour_ts]), 1, "etl_insert_time"),

("month", NAMEOF('mvpmonitoring'[insert_time_Year-Month]), 1, "etl_insert_time"),

("day", NAMEOF('mvpmonitoring'[insert_time_Year-Month-Day]), 1, "etl_insert_time"),

("hour", NAMEOF('mvpmonitoring'[source_time_hour_ts]), 2, "etl_source_time"),

("month", NAMEOF('mvpmonitoring'[source_time_Year-Month]), 2, "etl_source_time"),

("day", NAMEOF('mvpmonitoring'[source_time_Year-Month-Day]), 2, "etl_source_time")

}

How do I display the field parameter to sort by Hour, Day and Month? Currently, it's being sorted by alphabetical order.

The order of the time binning slicer should go something like this.

etl_update_time
-hour
-day
-month

etl_insert_time
-hour
-day
-month

etl_source_time
-hour
-day
-month

Thanks!

[danextian · Accepted solution]

Hi @Anonymous 

The order is based on these numbers:

Change them to 1 for hour, 2 for day and 3 for month.