Forum Discussion

muskan1111's avatar
muskan1111
Frequent Visitor
3 years ago

Conditional Drilldown when filter selected

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

Need Help
Show and Tell
Tutorial Requests

2 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    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's avatar
      muskan1111
      Frequent Visitor
      3 years ago

       

       

      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