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
jostnachs
Helper III
Helper III

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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