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

[bslyew]

Been working on this for a while. Have not been able to get it. I’ve been following tutorials such as Enterprise DNA’s:

Find Lists Of Your Top Clients Across Difference Measures w/DAX in Power BI

and Fourmoo’s

Dynamic TopN made easy with What If Parameter

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:

The data model is below:

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.

to_post_forum_example_500_afterTopN_v1.pbix

[sam.mckay]

Ok first thing, I would just look to setup this model slightly differently. It helps a lot in understanding everything that is going on.

I would setup it up more like this

I’m really not sure what this is doing, and I wouldn’t recommend it.

I cover modelling tips extensively in this course here, highly recommend diving into this when you can.

Data Transformations & Modeling

I would recommend trying out the TOPN function here.

See below for many examples

Different Ways You Can Use The TOPN Function - DAX In Power BI

And this is more specifically what you need I think

When To Use TOPN In Power BI - DAX Formula Review

Here’s another example using RANKX

Showcasing Top or Bottom Results Using Ranking Techniques - Power BI

See how you go with these ideas.

Thanks
Sam

[bslyew]

The above was me following a tutorial on creating Dynamic Attribute found on PowerPivotPro:

Dynamic Attributes In A Power BI Report - P3 Adaptive

I find end users want more consolidated visualizations and are not in favor of shows 3 graphs to display 1 measure for 3 different attributes:

What would you recommend for this functionality?

[sam.mckay]

Ok sure thing.

I guess now after seeing why you are doing this it makes a little more sense. It’s an interesting technique. Not one I’ve used a lot myself.

I would definitely look to organize you model still in the way I’ve described but look to place this somewhere so that it all flows seamlessly and is easy to understand.

Have you investigated the tutorial above utilizing the TOPN and RANKX functions. I think you should be able to get the calculations done here using the TOPN function. Let me know how you have got on testing this out.

I don’t recommend using the topnslicer functionality inside of Power BI, always look to write measures at all times. This is how you harness the immense analytical power contained within Power BI. You can then look to build on this in other calculations etc.

Sam

[bslyew]

Hi,

I have, I spent the last week working with Dynamic Attribute Slicers, Dynamic Measure Slicers, and combining it with TopN/RankX slicer table. Haven’t been able to get the logic. I know what needs to happen.

I’ll post this in another topic to open it up to everyone. Getting these 3 dynamic slicers would really help satisfy end users and help Power BI visualization makers succeed.

I really looked into your Global Statistics Power BI viz and worked from there.