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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Combining Dynamic Measure and Dynamic Attribute Slicer w/ TopN Ranking Slicer

Been working on this for a while. Have not been able to get it. I've been following tutorials such as powerbi.tips as below:

 

https://powerbi.tips/2018/02/crazy-table-gymnastics-part-2-build-support-materials/

 

and Fourmoo's 

 

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

 

The goal here is for end user's to be able to use a TopN slicer along with a Dynamic Attribute Slicer & a Dynamic Measure Slicer. Picture is below:ForumExampleDataViz.PNG

 

The data model is below:

ForumExampleDataModel.PNG

I found that most tutorials recommended putting that Selector table to select Attributes. It didn't work for me really, so I used the Pivoted Data[Attribute] instead for the Dynamic Attribute Slicer. How can we get the Top # of Items table connected to the Dynamic Attribute filter and the Dynamic Measure filter so that end users can filter out the TopN values. Example workbook is attached here

 

https://drive.google.com/open?id=1ijG1ViE7JaxubSF4izQhNHPgRLjqujQi

0 REPLIES 0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.