Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Grouping Field Parameter

Hello everyone,

I have a field parameter that looks like this.

time_field = {
    ("etl_update_time", 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'[update_time_hours]), 0),
    ("etl_insert_time", 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'[insert_time_hours]), 1),
    ("etl_source_time", 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_hour", NAMEOF('mvpmonitoring'[source_time_hours]), 2)
}

How do I group the parameter values into their own grouping in a slicer? For example, update_time etl_update_time breakdown should contain it's own month, day and hour. 

Currently, the slicer is showing like below, which is not ideal.

Thanks!

Need Help
Show and Tell
  • Idrissshatila's avatar
    Idrissshatila
    1 year ago

    Hello Anonymous ,

     

    the grouping will be after the last parameter shich is the sorting one as the follows

    time_field = {
    ("etl_update_time", NAMEOF('mvpmonitoring'[update_time_hour_ts]), 0, "group 1"),
    ("etl_update_time_month", NAMEOF('mvpmonitoring'[update_time_Year-Month]), 0, "group 1"),
    ("etl_update_time_day", NAMEOF('mvpmonitoring'[update_time_Year-Month-Day]), 0, "group 1"),
    ("etl_update_time_hour", NAMEOF('mvpmonitoring'[update_time_hours]), 0, "group 1"),
    ("etl_insert_time", NAMEOF('mvpmonitoring'[insert_time_hour_ts]), 1, "group 2"),
    ("etl_insert_time_month", NAMEOF('mvpmonitoring'[insert_time_Year-Month]), 1, "group 2"),
    ("etl_insert_time_day", NAMEOF('mvpmonitoring'[insert_time_Year-Month-Day]), 1, "group 2"),
    ("etl_insert_time_hour", NAMEOF('mvpmonitoring'[insert_time_hours]), 1, "group 2"),
    ("etl_source_time", NAMEOF('mvpmonitoring'[source_time_hour_ts]), 2, "group 3"),
    ("etl_source_time_month", NAMEOF('mvpmonitoring'[source_time_Year-Month]), 2, "group 3"),
    ("etl_source_time_day", NAMEOF('mvpmonitoring'[source_time_Year-Month-Day]), 2, "group 3"),
    ("etl_source_time_hour", NAMEOF('mvpmonitoring'[source_time_hours]), 2, "group 3")
    }

2 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    1 year ago

    Hello Anonymous ,

     

    the grouping will be after the last parameter shich is the sorting one as the follows

    time_field = {
    ("etl_update_time", NAMEOF('mvpmonitoring'[update_time_hour_ts]), 0, "group 1"),
    ("etl_update_time_month", NAMEOF('mvpmonitoring'[update_time_Year-Month]), 0, "group 1"),
    ("etl_update_time_day", NAMEOF('mvpmonitoring'[update_time_Year-Month-Day]), 0, "group 1"),
    ("etl_update_time_hour", NAMEOF('mvpmonitoring'[update_time_hours]), 0, "group 1"),
    ("etl_insert_time", NAMEOF('mvpmonitoring'[insert_time_hour_ts]), 1, "group 2"),
    ("etl_insert_time_month", NAMEOF('mvpmonitoring'[insert_time_Year-Month]), 1, "group 2"),
    ("etl_insert_time_day", NAMEOF('mvpmonitoring'[insert_time_Year-Month-Day]), 1, "group 2"),
    ("etl_insert_time_hour", NAMEOF('mvpmonitoring'[insert_time_hours]), 1, "group 2"),
    ("etl_source_time", NAMEOF('mvpmonitoring'[source_time_hour_ts]), 2, "group 3"),
    ("etl_source_time_month", NAMEOF('mvpmonitoring'[source_time_Year-Month]), 2, "group 3"),
    ("etl_source_time_day", NAMEOF('mvpmonitoring'[source_time_Year-Month-Day]), 2, "group 3"),
    ("etl_source_time_hour", NAMEOF('mvpmonitoring'[source_time_hours]), 2, "group 3")
    }