Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Top 10 Dashboard with Multiple Slicers

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.

 

Dinamyc Top 10  wit SlicersDinamyc Top 10 wit Slicers

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

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

Anonymous
Not applicable

I had reduced the data volume and it now work in desktop mode, when I have it published them it doesn

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.