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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
anusha_2023
Helper III
Helper III

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.