Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Text filter to multiple pages

Hello everyone!

I am creating a product catalogue in Power BI. On one page I have the contents, where there is a text filter option to search a product. The catalogue has 10 different families (so 10 different pages, because the pages have to be different between them). So if I search "PC", for example, a table of products that contains PC in the Index is shown, however some products are from family A and other products from B. I would like to choose one product (from the family A for example) and navigate to page of family A. That is done correctly, however, the lists of products shown in that family is only the selected product. I would like to show the products from that family with the searched word ("PC") on its name. 

How can I conserve the filtered word from the text filter? Is there a way to call this "selected value" (I tried selectedvalue function but it didn't call the "PC" value) and conserve it on another page?

I have tried the following options:

1) Only text filter (but text filter cannot syncronize within the other pages). I don't know if there is another way to do it.

2) Text filter and a Slicer choosing "All products", but, even if the filter is syncronized between pages, it does not delete the other non PC products.

3) I was thinking about doing it by an input text parameter from the user and using DAX someway (like filtering all the pages with a measure using the input text), but I cannot put a text parameter value in a power BI report (only in Power Queries).

What should I do? Is there any option?

Thank you!

7 Replies