Drill down not working properly

Question

I have two tables:

Table 1

Description	Number	category
Item 1	896504	item
Item 2	859677	item
Set 1	896432	set
Set 2	875321	set

Table 2

Set 1	Item 3	876543
Set 1	Item 4	876897
Set 1	Item 5	872457
Set 2	Item 6	865357
Set 2	Item 7	897634

both tables are connected to a 3rd table which has the qtys of

Description	qty
Item 1	6
Item 2	7
Set 1	8
Set 2	9
Item 3	0
Item 4	6
Item 5	4
Item 6	3
Item 7	5
Item 3	7

I want to illustrate the quantities in bar chart which shows the sets and when i drill down the set i can see the quantity of items in the set.

Currently I can illustrate each separately but doesn't work when trying drill down feature.

I am unable to connect table 1 to 2 because both of them connected to table 3 which has the quantities.

I can make changes in table 1 and 2 but not table 3 which i am connected to using direct query.

Answer 1

Add two helper column then put all the set in one column and another only for item.

Answer 2

An example are those tables:

 

 I want to show the sets as (bar chart) then when I drill down whatever in that set which has extra quantities should appear. In other words, if I pressed on set 1 I sthe bar chart should show showing the qty of single chair only as we don’t have extra quantities for squared table. But if I pressed set 2 I will get both single chair and rectangular table quantities.

 

 

Answer 3

Could you share a screenshot of your slicers or filter? Could you also share an expected result?

Then I can give suggestions on it.