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 mostly followed and tried to reverse engineer the logic of @sam.mckay with the Showcase Power BI Viz, specifically the Global Statistics dashboard. I also used tutorials on Disconnected Slicers 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.
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 click here or download below.