List of Values based on Selected Value

[Anonymous]

Hi All,

Could you please help me to solve this scenario.

I have attached required data in excel.

https://docs.google.com/spreadsheets/d/10Ok2ZYakQOD85XsVXDkHKok4kgbyxZ1M/edit?usp=sharing&ouid=11458...

Thank you.

[v-cazheng-msft]

Hi @Anonymous 

Not sure about your calculation logic so we couldn’t provide a formula or sample file to you, but we do provide drill down and drill through to display focus data. Here are the related documents you may refer to:

Set up drillthrough in Power BI reports - Power BI | Microsoft Docs

Drill down and drill up in a visual - Power BI | Microsoft Docs

Set up drillthrough in Power BI reports - Power BI | Microsoft Docs

Best Regards,

Community Support Team _ Caiyun

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