Forum Discussion
Helper IIFilter on two Pages (no drill trough)
Hello everybody,
let's say you have two pages, the one is an overview with some tables and some filters and the other is a "export" overview, also it holds all the data, that in the other pages were in order to be exported (lets say as a screenshot or a csv).
Now I want the second page be reachable through a "Export" Button in Page 1 and to show only the data that have been selected through the filtering in Page 1.
I don't think it is a drilltrough, since it is still an overview and not necessary a detail view of a single unit.
Can you help me here?
Thank you in advance!
2 Replies
- MAwwad
Solution Sage
One way to achieve this is by using a bookmark. Here's an overview of the process:
Create a filter on the first page that allows you to select the data that you want to export.
Create a second page that shows all the data that you want to export.
On the first page, apply the filter to the visuals on the page, so that only the selected data is shown.
Create a bookmark of the first page, so that the filter and the selected data are saved.
Create a button on the first page, and use the "Navigate" action to navigate to the second page.
In the "Navigate" action, select the option to "Apply a bookmark" and select the bookmark that you created in step 4.
This will ensure that when you navigate to the second page, the filter from the first page is applied, so that only the selected data is shown.
You can also add a button to export the data in the second page to csv, excel or pdf.
By following these steps, you will have a export button in the first page which allows you to navigate to the second page with the filtered data from the first page and export it to different formats.
- NewPBIe
Thank you for your answer. But I am afraid this won't work.
The filtering possibilities on the first page are more than one - basically every user of this dashboad should be able to filter his own region and export his own view. As I understand it, the bookmark-solution would only take a selection and save it for every user.
