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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
anusha_2023
Helper IV
Helper IV

Multiple Filed parameters with same set of slicer names on the same page

I do have two Field Parameters as below which have same set of names but different measures. I need to use these two parameters in two matrices in the same report page. 

 

ScenarioFuncParameter = {
    ("Actual", NAMEOF('#Measures'[Coalses Functional Actual]), 0),
    ("Budget", NAMEOF('#Measures'[Coalses Functional Budget]), 1),
    ("Forecast1", NAMEOF('#Measures'[Coalesces Functional Forecast1]), 2),
    ("Forecast2", NAMEOF('#Measures'[Coalesces Functional Forecast2]), 3),
    ("Forecast3", NAMEOF('#Measures'[Coalesces Functional Forecast3]), 4)
}
 
ScenarioGMParameter = {
    ("Actual", NAMEOF('#Measures'[Actual GM]), 0),
    ("Budget", NAMEOF('#Measures'[Budget GM]), 1),
    ("Forecast1", NAMEOF('#Measures'[Forecast1 GM]), 2),
    ("Forecast2", NAMEOF('#Measures'[Forecast2 GM]), 3),
    ("Forecast3", NAMEOF('#Measures'[Forecast3 GM]), 4)  
}
 
Can I use one set of buttons as below for changing measures for both matrices.
anusha_2023_0-1736145284490.png

 

do I have any workaround other than repeating burrons twice for each matrix?

1 ACCEPTED SOLUTION
SamWiseOwl
Super User
Super User

Hi @anusha_2023 

 

If I have understood correctly you want one slicer that changes both field parameters?

SamWiseOwl_0-1736177928745.png

 

Create a new table (Enter Data) that lists out the names of the measures:

SamWiseOwl_1-1736177960160.png

 

Join this onto the other two parameter tables:

SamWiseOwl_2-1736177988159.png

I set both of these to One to Many and Single Direction then set to active:

SamWiseOwl_3-1736178026463.png

 

Finally add the new master list into a slicer and enjoy:

SamWiseOwl_4-1736178058310.png

 

 


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

View solution in original post

2 REPLIES 2
SamWiseOwl
Super User
Super User

Hi @anusha_2023 

 

If I have understood correctly you want one slicer that changes both field parameters?

SamWiseOwl_0-1736177928745.png

 

Create a new table (Enter Data) that lists out the names of the measures:

SamWiseOwl_1-1736177960160.png

 

Join this onto the other two parameter tables:

SamWiseOwl_2-1736177988159.png

I set both of these to One to Many and Single Direction then set to active:

SamWiseOwl_3-1736178026463.png

 

Finally add the new master list into a slicer and enjoy:

SamWiseOwl_4-1736178058310.png

 

 


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

Perfect Solution. Thanks a lot.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors