Top N filter is not an option

[jbsgl]

How can I filter my page on Top N? I see only basic and advanced filtering options.

I would like to show only the top 10 of PV_PREMIUM in all visualisation on my page.

If I need to create a rank measure, I need to rank based on PERIOD and MARKET columns (they are not measures) so that the ranking changes depending on my PERIOD and MARKET slicers on the page.

Thanks

[npergand · Accepted solution]

The Top N filter option appears as an option in the "Filters on this visual" filter section. 

So you could apply it at that level for all visuals on that page.

Otherwise you are looking at performing some DAX or Power Query modeling to accomplish what you are looking for.