Forum Discussion
Field Parameters Grouping/multiselect
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
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! 🤠
4 Replies
Daniel29195 , Thanks for solution.. worked perfectly
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! 🤠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! 🤠
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
