Forum Discussion
Responsive ResidentOmit filter from drill through
Hi Anonymous , thank you for your reply.
I am trying to find a way that gives the best user experience and would prefer to avoid asking the user to filter the summary page and then apply the same filters (except product) to the drill through page.
In the end I found another solution:
I referenced the fact table and connected it to all dimesions except the product table, I then used the referenced table in my drill through page which is not filtered by the product dimension. The downside of this approach is that I can't drill through on the measure and instead need to drill through on my dimensions, but I think it gives me the outcome that is best for user experience.
Super UserIf you're unable to remove the product filter from the summary page because a product must always be selected, we can adjust the approach slightly. Here's how you can handle the scenario:
Create Drill-through Filters:
- Configure the drill-through filters in Power BI Desktop for the drill-through page as mentioned before.
Create a Dummy Product Filter:
- On the summary page, create a dummy slicer or filter for the product field. This could be a slicer with all product options available, but defaulting to a specific product or allowing multiple selections.
- Ensure that this dummy filter is always selected or defaults to a specific product.
Drill Through:
- Navigate from the summary page to the drill-through page using the drill-through action.
Maintain Other Filters:
- Since the dummy product filter is always selected, it won't affect the drill-through action, and all other filters except the product filter will be carried forward to the drill-through page.
Adjust Drill-through Page Layout (Optional):
- On the drill-through page, you can choose to hide or disable the dummy product filter slicer to avoid confusion.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
- On the drill-through page, you can choose to hide or disable the dummy product filter slicer to avoid confusion.
Responsive ResidentSorry, I'm not following. I'm unsure what the purpose of a dummy product slicer is when I already have an actual product slicer