Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 how you drag that once you click TOP10 button, the bookmark always stays at the same one requested parameter while all filters are applied and then you can go back to full display? I dont have much space, so if I can done it in one button would be fantasitc
@Pbiuserr , 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
Hi 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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
123 | |
78 | |
48 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |