Forum Discussion

Julia2023's avatar
Julia2023
Helper I
3 months ago
Solved

Dynamic Top N Ranking with Bucket-Based Filter Context

Hi all, I need advice on implementing a dynamic Top N ranking filter in Power BI. I have 2 visuals on the same page: A matrix that groups products into different sales and profitability buckets (f...
Need Help
Show and Tell
Tips and Tricks
  • v-sshirivolu's avatar
    v-sshirivolu
    3 months ago

    Hi Julia2023  ,

    I was able to reproduce the scenario successfully using a sample dataset, and the ranking/filtering worked correctly with the shared approach.

    I have attached a sample PBIX file for reference so you can compare the implementation with your current model/setup.

    If the issue still exists, please share the following details - 

    sample data/model structure
    expected output
    current output screenshot

    so the exact filter context behavior can be reproduced and checked further.

    Thank you.

v-sshirivolu's avatar
v-sshirivolu
Community Support
3 months ago

Hi Julia2023  ,

I was able to reproduce the scenario successfully using a sample dataset, and the ranking/filtering worked correctly with the shared approach.

I have attached a sample PBIX file for reference so you can compare the implementation with your current model/setup.

If the issue still exists, please share the following details - 

sample data/model structure
expected output
current output screenshot

so the exact filter context behavior can be reproduced and checked further.

Thank you.

v-sshirivolu's avatar
v-sshirivolu
Community Support
3 months ago

Hi Julia2023 ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you