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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.