Forum Discussion
Combining Dynamic Attribute Slicer, Dynamic Measure Slicer, and Dynamic TopN /RANKX Slicer
Super UserHi 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
Hello MFelix
- 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?
- 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)
- I do this through multiple disconnected slicers as in the powerpivot pro article I linked to.
- 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)
- How does that match with the VALUES on the X-Axis on the chart?
- 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
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.
- 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?