Ranking on page level filter

[Minnie]

Hi,

I'm pretty new to Power BI and I have a report that need to have a page level filter on top 10 products and then can change based on which year you choose in the slicer. But I just can't get this to work, so I hope that someone in here have some awseome solution!

I will be grateful for any help that is provided

Regards

[v-ljerr-msft · Accepted solution]

Hi @Minnie,

---

I'm pretty new to Power BI and I have a report that need to have a page level filter on top 10 products and then can change based on which year you choose in the slicer. But I just can't get this to work, so I hope that someone in here have some awseome solution!

---

Currently, we can only use columns to apply a page level filter. However, not like measures, calculate columns computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report. So I don't think you can have a page level filter on top 10 products and then can change based on which year you choose in the slicer.

An alternative way I can think of is creating a measure to calculate the Rank, then use the Rank measure as visual level filters for all visuals on your report to get the top 10 products, which can change based on which year you choose in the slicer. Here is an article about calculating ranks dynamically based on Slicer for your reference. 

Regards

[Minnie]

Hi @v-ljerr-msft,

Thank's for the answer. 

I have written a mdx-query that loading top 10 from the cube, but it´s a static solution.

I have looked at the visual level filter for the slicer, maybe it is an option.

Regards