Filter Product Related to an Associate Selected in A Different Visual

[kingkong]

I have a dataset contains Associate, Date, Product and Hours.

Using this dataset, I created a visual with Associate, Processed Units, Total Hours, and Units/Hour. The visual is filtered by Date. Processed Units = Count(Product) and Total Hours=SUM(Hours)

I want to create another visual, which is filter by another date filter. But when an associate is selected from the previous visual, his visual will finds all the product that the associate worked on, and calculate the Processed Units, Total Hours, and Units/Hours of the products that this associate worked on.

Is this kind of filtering possible in Power BI? Can it be solved with DAX or better data modeling? 

[TeigeGao · Accepted solution]

Hi @kingkong ,

According to your description, my understanding is that you don't want to let the filter in a visual affects another visual, in this scenario, we can use the Format > Interactions to change this affect, for more information, I would suggest you refer to this document: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Best Regards,

Teige