Forum Discussion
Pbiuserr
Post Prodigy
Post ProdigyTOP N best approach
Hello, I have a field parameter containing 5 dimensions For one dimension I need be able to display either full chart or TOP N (lets say TOP 10) How to achieve that? By bookmarks? If yes, then ...
amitchandak
Super User
Super UserPbiuserr , Create a TOPN measure using what if and keep the value of N very high initially, you can change it 10 to a number as per need. This value can be saved with a bookmark too
PbiuserrPost Prodigy
Post ProdigyHi Amit,
Thanks its really interesting. My question is: what if I have in chart (so table in this way) two measures. It filters properly like TOP10 from desired measure, but it left also the ones who have any value in previous one (like Sales Amount and Sales amount LY). It gives me TOP10, but also any other value in axis which got anything in Sales amount LY. Any way to solve that?