Conditional Drilldown when filter selected

[muskan1111]

Hello Everyone! Problem Statement : I have a table in which I want to get data based on filters. I created a feild parameter for Level 1, Level 2, Level 3. 

Now the condition is If I select Level 1 filter (In slicer) then the table must show the values of Level 2 
if Level 2 filter( In Slicer) selected then table must show the values of Level 3  values. 

I'm trying to do it without using drilldown mannually. If anyone have any idea how to do this, That would be helpful.

Thanks in advance

[v-yalanwu-msft]

Hi, @muskan1111 ;

Sorry, I can't understand it for the time being, can you share some scenes and the result display you want to output?

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

[muskan1111]

 

Here In 1st img there are 3 filters region, State, city.
When no filter is selected it should show region table 
If Region is selected then it should show State table
If State has selected it should show City table