Drillthrough using one filter instead of 2

[amirabedhiafi]

A Drillthrough page has two fileds in Drillthrough filters  :

• MonthName
• CustomerName

On Main Page, in Visual there is only one field available CustomerName.

How can wwe Navigate to Drillthrough page from Main page ?

[Anonymous · Accepted solution]

Hi  @amirabedhiafi ,

1. Create a main page with only one customername field and a drillthrough page with other fields

2. Pull the customername field to the bottom of visualizations and add drill through fields here

3. Right click on the main page and select a value in the customername field, drill through – drill through page

4. The drill through page will only display the data corresponding to the selected value as it changes

You can downloaded PBIX file from here.

This is the link of related content,hope it can help you

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

Best Regards

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nandic]

Hi @amirabedhiafi ,
On drillthrough page you define fields used for filtering that page.
If on drillthrough page you add field "Customer" in drillthrough section and on main page you have used field "Customer" on visualization, you will have option to navigate from main page to drillthrough page (right click on field Customer on main page and choose drillthrough).
If you didn't specify field "Customer" on drillthrough page in drillthrough section, then you wouldn't be able to navigate from main page to drillthrough page using Customer field.

Regards,
Nemanja Andic

[parry2k]

@amirabedhiafi  right-click on the data point of a visual on the main page, and you will see the drill through option in the menu and that is how you will get to it. You can also create buttons for drill thru and read more about it here.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡