Assistance Needed: Implementing BANs as KPI Selectors in Power BI

[manoj_0911]

Hello Power BI Community,

I'm currently working on implementing BANs (Big A** Numbers) as KPI selectors in my Power BI dashboard. I came across this informative article (link attached: [Building Better Dashboards Through Interactivity](https://www.cleartelligence.com/post/building-better-dashboards-through-interactivity-part-2-using-b...)) and I'm looking to replicate the functionality described.

**Key Requirement:**
- When selecting a BAN representing a specific KPI (e.g., sales, profit, quantity), the top 10 products displayed should be based on the selected KPI.

Attached are the detailed requirements for reference.

I'd greatly appreciate any guidance, insights, or step-by-step instructions on how to achieve this functionality in Power BI.

Thank you for your assistance and expertise!

Best regards,
Manoj Prabhakar

[Anonymous · Accepted solution]

Hi @manoj_0911 ,

Based on the information you provided, to dynamically display the top 10 products based on the selected KPIs, you can set up bookmarks to capture the status of the report pages selected for each KPI. These bookmarks are then triggered using a button or image to effectively filter the display to show the top 10 products for the selected KPI.
You can follow the steps below:

1.Add index column and create a column.

result =
VAR _1 =
    RANKX (
        FILTER ( ALL ( 'Table' ), 'Table'[Number] = EARLIER ( 'Table'[Number] ) ),
        'Table'[Amount],
        ,
        DESC
    )
RETURN
    IF ( _1 <= 10, 'Table'[ID], BLANK () )

2.Create two filtered bookmarks.

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

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