Combining Dynamic Attribute Slicer, Dynamic Measure Slicer, and Dynamic TopN /RANKX Slicer

[Anonymous]

Hey All. 

Been working on this awhile, still can't get it. Want to combine Dynamic Attribute Slicer, Dynamic Measure Slicer, and Dynamic TopN /RANKX Slicer. The goal here is to allow end users to toggle within a slicer between TopN choices for a given attribute they select and given measure they select. I was using tutorials from PowerPivotPro and FourMoo on disconnected slicers and such.

Currently the TopN Slicer is giving the Top10 values for all values within the AttributeSlicer.  It needs to give the TopN within the specific group in that column. Look at the global stats worksheet.use the global stats worksheet

I have an idea of what needs to happen. I imagine the Rank Selection isn't able to drill down into the Top 5 for the specific attribute so some sort of a groupby or virtual calculated table needs to occur.  Solving this problem would really help Power BI Datanauts create stellar dashboards. Any help? Example Power BI is in the link. 

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

[MFelix]

Hi @Anonymous ,

Can you please share some more insigths on what you want to achieve.

If I understood correcty you want to have the top 5 / 10 / ... (user selection), attribute  (also user selected) and return or the total Budget value or Invoice correct?

How does that match with the VALUES on the X-Axis on the chart?

Not understanding how you have the values on chart but then pickup the slicer values.

Regards,

MFelix

[Anonymous]

Hello @MFelix 

1. If I understood correcty you want to have the top 5 / 10 / ... (user selection), attribute  (also user selected) and return or the total Budget value or Invoice correct?
   1. Yes. 3 slicers. All dynamic. Slicer 1) Top 5/10... (user selected), Slicer 2) Attribute Slicer (User Selected) , Slicer 3)  Dynamic Measure Slicer (User Selected)
      1. I do this through multiple disconnected slicers as in the powerpivot pro article I linked to. 
2. How does that match with the VALUES on the X-Axis on the chart?
   1. Through a disconnected slicer

[MFelix]

Hi @Anonymous ,

Regarding question 2. you want to have your measures based on the values per each invoice? is that the result you want to have?

Assuming that you have 2 invoices with value 10 and the budget sums 60 you want to have that 60 in the chart?

Regards,

MFelix

[Anonymous]

Currently, the values are based upon the values column  in the AttributeSlicer. The Value should change based upon what is selected by the User. So if they want to know the Invoice Dollar Sum Amount, the whole graph will change.