Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

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...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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.