cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rajshree_shinde Frequent Visitor
Frequent Visitor

problem in Drill Through

I have data with 2 tables. One table has country, city, Area (mall, office, residential). 2nd table has area, floor, sectors etc.

We are showing map for country and city. when I Dirll through from city it should take me to area which is corresponding to that city But it takes me to all areas.

e.g. in dammam it should take me to only residential area but it shows all areas.( for area we are using treemap)

so please assist us how can be this resolved.

4 REPLIES 4
Rajshree_shinde Frequent Visitor
Frequent Visitor

Problem in Drill through

I have data with 2 tables. One table has country, city, Area (mall, office, residential). 2nd table has area, floor, sectors etc.

We are showing map for country and city. when I Dirll through from city it should take me to area which is corresponding to that city But it takes me to all areas. 

e.g. in dammam it should take me to only residential area but it shows all areas.( for area we are using treemap)

so please assist us how can be this resolved.

Moderator v-yuezhe-msft
Moderator

Re: problem in Drill Through

@Rajshree_shinde,

Make sure that you set the value of Cross Filter direction to Both. You can review the example in this PBIX file. If drillthrough still doesn't work in your PBIX file, please share dummy data of the two tables, and describe more details about what fields you use to create visuals. 

1.JPG



Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Rajshree_shinde Frequent Visitor
Frequent Visitor

Re: problem in Drill Through

Thanks for the response but still it is not working at some level.

let me brief you

we have 4 tables:

table 1 has country, city, and area. where area are three: Residential, Mall, office

table 2 has an area, building, floor, sector. where the area is 'Residential'

table 3 has an area, building, floor, sector. where the area is 'Mall'.

table 4 has an area, building, floor, sector. where the area is 'office'.

in the report, I want to show the map on the first page- there is drill down from country to the city. 

on the 2nd page, We want to drill through from city to all area's. where it should show only areas which come under that city.

and on 3rd page, drill through from area to building or floor. then floor to sector

 I tried to implement by combining all data of table 2, 3, and 4. and all drill-down and drill-through features working fine except sector. 

for example, when I drill through from 6 floor to sector it shows all sectors of the 6th floor of all Area. where as it should show sectors of 6 floor of particular area

please advice why it is not working.

 

Moderator v-yuezhe-msft
Moderator

Re: problem in Drill Through

@Rajshree_shinde,

What relationship do you create among these tables?

Could you please share a dummy PBIX file so that I can check?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.