Specify or limit parameters to be passed to visual

[Anonymous]

I'm wondering how I can limit or specify the parameters to be passed to a visual when a user clicks on a table row?  For instance, my table shows the latest quarter's snapshot of data about a vendor's products.  My graph shows the aggregated historical information of all that vendor's products.

However, when the user clicks on the table row, the graph automatically filters itself by latest quarter, only showing that time period's data for the selected product.  I would like my graph to also show the historical data of the selected product, and not just the latest quarter's snapshot. 

Thanks in advance!

[amitchandak · Accepted solution]

@Anonymous , Not very clear to me. See if interactions can help.

Switch off interactions - https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

or use a measure with all on period, but the product can pass.

[Anonymous]

Hi Amit,

Thanks for your reply.  Could you elaborate more on the measure method?  Not sure I understand what you're suggesting.  I've tried changing interactions but it's not letting me do what I need as the options are limited.

Thanks.