Forum Discussion

pavanmanideep's avatar
pavanmanideep
Helper III
3 years ago

Design report with multiple drill downs from same table with different conditions and performance

Hi BI Folks,

 

I am very new to Power BI....and need to implement multi level drop downs from the same table as shown in the below image.

 

I was able to acheive the drilldown until 2 levels until cluster, but couldnt understand how to go further on this as for the next level each item has a filter criteria. Kindly note all this data should come from same table.

 

Also my dataset will load 4 Million records, so please suggest if Power BI can handle such a large volume without any performance issues.

 

Kindly help me with above queries, currently I am using Power BI desktop.

 

Drill down

Need Help
Show and Tell

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    What you describe is standard Power BI functionality. Go ahead and design your report with your data. Use a matrix visual for the drilldowns.

    • pavanmanideep's avatar
      pavanmanideep
      Helper III
      3 years ago

      Hi lbendlin ,

       

      Ok, thank you very much for your reply...please let me try it out with Matrix visual and update here. But after the cluster, the next drill down should segregate based on conditions like Eligible, Not Eligible...etc.

       

      Also please suggest any resources or pointers on how to achieve this. Your response is greatly appreciated.

       

      Regards,

      Pavan Mani Deep Y