How to filter a dashboard table?

[Anonymous]

Hi,

In my power query I have two tables: the sales table and product information table.

The product information table for now has just two columns: the name of the product and the ROE of that product. I also added a avarege ROE for the products, so my table is like:

Product	ROE
Notebook	15%
Smartphone	12%
Avarege	13,5%

Here's my problem: my dashboard has many informations, and I'd like to when I click on a product from a "Menu Product", it shows the ROE of that product. But if I don't click at any product, I'd like to show the Avarege ROE of all products mixed. How can I do that?

[V-pazhen-msft · Accepted solution]

@Anonymous 

It is not possible to filter the dashboard visuals. Because visuals in a dashboard are from many reports and datasets, you cannot filter data form different sources as they are not related to each other.

I would suggestion you to use "Pin Live Page". You can pin the whole report page to dashboard including slicers to make it interactive.

https://docs.microsoft.com/en-us/power-bi/service-dashboard-pin-live-tile-from-report

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[JakubBalaj]

Before, it was possible (5 years ago), I had Dashboards for every product, one dataset with all producs and every Dashboard was filtered by one. I dont understand why Microsoft removed this function.

Now we have just two solutions:
1) create "Work_Sheet", duplicate visuals with filtered value and use them for Dashboard

2) filter visuals and publish Report to services. Select visuals and add to Dashboard. Rollback filters with publishing Report again with default filtering - dashboard still holds filters after that.