Drillthrough with many levels

[GeorgeNelzo]

Hi, 

I need to create one report with master detail with many levels in many pages. Like

Country > State > City > Region

One page for each one.

With DrillThrough is working fine to first level to second... afetr that is noth showing any more the DrillThrough option to next page...

Have any ideas ??

[Anonymous]

you need to add all columns that is state city region in drill through filters.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[GeorgeNelzo]

I tryied this... Also I tryied the Hierachie, the lookup but... In my case the the Region can have mora than one City...

With This, I cannot user the these...

Any Idea ? 

[V-lianl-msft]

Hi @GeorgeNelzo ,

You need to confirm whether they correspond to each other in your table.

If so, then the hierarchy is fine.

Before we build a hierarchy, we’ll need to know the levels that comprise the hierarchy. The levels are Country > State > City > Region.

If the problem persists,could you please share sample data or sample pbix?

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

[GeorgeNelzo]

Sorry... i used contry and states to have one exemple, but thats not a good example...

My structure is like this: https://prnt.sc/qrs9ev

I have one table with itens...  each iten have one code with father code...

This fathers also is one iten...

In the end I need to see the Tree with the values and more staffs...

The problem is each can be in diff fathers