Forum Discussion
Sort Field Parameter
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!
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!
Hi Anonymous
The order is based on these numbers:
Change them to 1 for hour, 2 for day and 3 for month.
1 Reply
Hi Anonymous
The order is based on these numbers:
Change them to 1 for hour, 2 for day and 3 for month.