Forum Discussion
Limit items in visual (TOPN?)
Hi, I want to know if it's possible to limit the number of items in a visual to 10 or so, giving Power BI some conditions. For example, I have 300 results por stores, for each store I know th...
Reading this a little closer, I think perhaps you need what I call a Complex Selector. So, you create a measure that essentially returns 1 when the conditions you specify are met and a 0 when they are not and then you use this measure to filter your visual. The concept is based on the Inverse Selector. https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290#M325
I have attached an example and will attach another one.
Here is another example (below)