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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
jostnachs
Helper IV
Helper IV

How to set parameters to act only one visual but not the other in paginated reports

Hi all... 

I have a requirement as I have two visuals with two different data sets. i have to export them into same excel workbook with different sheets with a pagebreak after the dataset1. now i have to set different parameters for each visual.i.e I want my parameters to effect only on visual1 not on visual2. can I acheive that? 

jostnachs_0-1726581716212.png

Above is my report with two table visuals. but i want my parameters to effect only on ly visual1 not on visual2. How can i do that?(like edit interactions in power bi descktop)

 

thanks,

 

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@jostnachs you can do whatever you want. Report builder allows control of every aspect of the report. Maybe for visual 1, you should filter query data based on the parameter and do nothing to visual 2 query. So data returned by visual 1 query will always respond to the parameter values entered by the user.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

2 REPLIES 2
parry2k
Super User
Super User

@jostnachs you can do whatever you want. Report builder allows control of every aspect of the report. Maybe for visual 1, you should filter query data based on the parameter and do nothing to visual 2 query. So data returned by visual 1 query will always respond to the parameter values entered by the user.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Great! Make sense... i tried and it worked. I changed the visual2 removed the filter condition and removed the parameters and it worked fine.

 

thanks for the help

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.