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.
Hi all good afternoon
I´ve being looking and trying all solutions I could find, but I’m still facing problems, so I would like to see if you can help me.
Request: I need a dynamic top 10 dashboard that returns depending on the selected filters “Slicers” the top 10 elements.
Obs: The slicer elements aren’t at the same table, but they are all related to the fact table
Additional Information: Not sure if it can be reached out with Rank function, what I already had tried, with the following formula (IF ( HASONEVALUE ( Products[Corp] ),RANKX ( ALLSELECTED ( Products[Corp] ), CALCULATE(FACT[CURRENT MAT VALUE]), [CURRENT MAT VALUE],0,Dense))… but so I have a single context, and I need it to create a new one whenever the user choose a slicer element, or by row count.
HI @Anonymous,
I'd like a pbix file with some sample data for test and coding formula.(you can upload it to onedrive or google drive and share link here)
Regards,
Xiaoxin Sheng
I had reduced the data volume and it now work in desktop mode, when I have it published them it doesn't work as expected and as in desktop mode...
I will try to set a sampledatabase and share the examples with you
Thank you
I had reduced the data volume and it now work in desktop mode, when I have it published them it doesn
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |