Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ak77
Helper V
Helper V

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 

ak77_0-1707950668454.png

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")
   
}
1 ACCEPTED SOLUTION

@ak77 

check below : 

Daniel29195_0-1708024798558.png

 

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 : 

Daniel29195_1-1708024849402.png

 

 

 

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. 

Daniel29195_2-1708024919141.png

 

 

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! 🤠

 

View solution in original post

4 REPLIES 4
ak77
Helper V
Helper V

@Daniel29195 , Thanks for solution.. worked perfectly

ak77
Helper V
Helper V

@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
Super User
Super User

@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! 🤠

@ak77 

check below : 

Daniel29195_0-1708024798558.png

 

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 : 

Daniel29195_1-1708024849402.png

 

 

 

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. 

Daniel29195_2-1708024919141.png

 

 

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! 🤠

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.