cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Why is when I do a drill through, the drill trough's filter is on a wrong table ?

I have this bar chart : 

FlameMoon_0-1637244119803.png

 

When I right-click in the "ret200" bar chart, I have this menu :

FlameMoon_1-1637246416932.png

So it gives me the option to drill through an other page "Détails défauts" that contains a table with the details of the "ret200" values (article, code, description, quantity, etc.).

The table is supposed to show me only the value for the selected bar chart which is in my case "ret200".

But here is the problem, the table contains values that aren't "ret200".

Here is a simplified example :

 

FlameMoon_5-1637247246721.png

In this case, when I do the drill through, it shows me "ret200" which is correct but it also shows me "ret100" which is not correct.

I found where the problem is, but I can't find a way to solve it.

In the Drill through's filter, it creates me a few filters. One of them contains the value of the bar chart that I right clicked on it.

FlameMoon_6-1637247563847.png


"Defect_text" is automacialy filled with "ret200 - defect" which is the text of the item "ret200" (the one selected) and then you say to yourself that the drill through worked well? I thought so...

But the filter is refered to the wrong table in my model. 

As you can see :

 

FlameMoon_7-1637247792241.png

 

I have two columns (foreign key) that are named "defect_text", one is in "Inventory" and the other one is in "Quantity".

And my drill through automaticaly add a filter on Inventory's defect_text but the table's values are based on the Quantity's defect_text, so yes the drill through works well but on the wrong table.

So I have a few question.

  1. Is it a relational problem ? 
  2. Can I say to Power BI "use Quantity's defect_text for the drill through", or change the table ?
  3. Is this problem solvable ? 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I found the solution.

The solution was to use directly the DEFECT table since it's a dimension's table.

So, in the shared's axis of my bar chart I simply deleted the old defect_code values (since it was from the wrong table) and I added the defect_code from my dimension's table. 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

I found the solution.

The solution was to use directly the DEFECT table since it's a dimension's table.

So, in the shared's axis of my bar chart I simply deleted the old defect_code values (since it was from the wrong table) and I added the defect_code from my dimension's table. 

amitchandak
Super User
Super User

@Anonymous . hope code type was there in the list "add drill through parameter"?



New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!
Anonymous
Not applicable

I didn't setup the drill through. Power BI automaticaly added me the option.

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors