Field Parameters Grouping/multiselect

[ak77]

Hi All, 

i need help in field parameters Grouping or multi select.Below is thee display of my field parameter and snippet. I need a logic for last 2 fields Start Date and Since Inception, if One is selected, The Other should also get selected and displayed . or is there any other approach to achieve this ? please let me know 

AnnualizedYearsParameter = {

    ("1 year", NAMEOF('Returns_Measures'[1 year-V1]), 0,"1"),

    ("2 Year", NAMEOF('Returns_Measures'[2 Year-V1]), 1,"1"),

    ("3 Year", NAMEOF('Returns_Measures'[3 Year-V1]), 2,"1"),

    ("4 Year", NAMEOF('Returns_Measures'[4 Year-V1]), 3,"1"),

    ("5 Year", NAMEOF('Returns_Measures'[5 Year-V1]), 4,"1"),

    ("6 Year", NAMEOF('Returns_Measures'[6 Year-V1]), 5,"1"),

    ("7 Year", NAMEOF('Returns_Measures'[7 Year-V1]), 6,"1"),

    ("8 Year", NAMEOF('Returns_Measures'[8 Year-V1]), 7,"1"),

    ("9 Year", NAMEOF('Returns_Measures'[9 Year-V1]), 8,"1"),

    ("10 year", NAMEOF('Returns_Measures'[10 year-V1]), 9,"1"),

    ("11 Year", NAMEOF('Returns_Measures'[11 Year-V1]), 10,"1"),

    ("12 Year", NAMEOF('Returns_Measures'[12 Year-V1]), 11,"1"),

    ("13 Year", NAMEOF('Returns_Measures'[13 Year-V1]), 12,"1"),

    ("14 Year", NAMEOF('Returns_Measures'[14 Year-V1]), 13,"1"),

   ("Start Date",NAMEOF('Returns_Measures'[_Node Start_Date]), 14,"Inception"),

   ("Since Inception",NAMEOF('Returns_Measures'[SinceInception-V1]), 15,"Inception")

}

[ak77]

@Daniel29195 , Thanks for solution.. worked perfectly

[ak77]

@Daniel29195  Thanks much for reply. I tried and was not able to do as u mentioned.. Can u please help with a mock report and pass it if its not much . Thanks again

[Daniel29195]

@ak77 

2 options : 

the method you are using im assuming, ( you grouped the last 2 by -- Inception ) 

then use this column in the slicer . 

another option is the following : 

create first field paramter  as fllow : 

AnnualizedYearsParameter = {

    ("1 year", NAMEOF('Returns_Measures'[1 year-V1]), 0,"1"),

    ("2 Year", NAMEOF('Returns_Measures'[2 Year-V1]), 1,"1"),

    ("3 Year", NAMEOF('Returns_Measures'[3 Year-V1]), 2,"1"),

    ("4 Year", NAMEOF('Returns_Measures'[4 Year-V1]), 3,"1"),

    ("5 Year", NAMEOF('Returns_Measures'[5 Year-V1]), 4,"1"),

    ("6 Year", NAMEOF('Returns_Measures'[6 Year-V1]), 5,"1"),

    ("7 Year", NAMEOF('Returns_Measures'[7 Year-V1]), 6,"1"),

    ("8 Year", NAMEOF('Returns_Measures'[8 Year-V1]), 7,"1"),

    ("9 Year", NAMEOF('Returns_Measures'[9 Year-V1]), 8,"1"),

    ("10 year", NAMEOF('Returns_Measures'[10 year-V1]), 9,"1"),

    ("11 Year", NAMEOF('Returns_Measures'[11 Year-V1]), 10,"1"),

    ("12 Year", NAMEOF('Returns_Measures'[12 Year-V1]), 11,"1"),

    ("13 Year", NAMEOF('Returns_Measures'[13 Year-V1]), 12,"1"),

    ("14 Year", NAMEOF('Returns_Measures'[14 Year-V1]), 13,"1"),

   ("Start Date",NAMEOF('Returns_Measures'[_Node Start_Date]), 14,"Inception"),

}

create second field paramter : 

second_field_param = {

("Since Inception",NAMEOF('Returns_Measures'[SinceInception-V1]), 15,"Inception")

} 

now link both field paramters on the column added ( which contains the values 1 ,  and Inception) 

add both field paraamters to the visual ,

now, each time you select start date from the first field paramter, the other will show .

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Daniel29195 · Accepted solution]

@ak77 

check below : 

in the field paramter, add a new columns ( in my case i have created a column with values group1 , group2) 

a new column  will appear : 

drag and drop this column ( value4)  to the slicer . you will have the same slicer i have in the first image. 

now if i click on GROUP2 , it will show, only sales ,

however if click on GROUP1 ,  it will show qty and count. 

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠