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

[pavanmanideep]

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

[lbendlin]

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]

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