Forum Discussion
Button/Filter | Button trigger and filter values
Hello,
short directly question, is it possible to create a button which trigger a measure which only show 3 supplier at my table?
Or are there other solutions?
File:
https://1drv.ms/u/s!Ar9P7_DTkCuW5W5ELYRAQ877do7Y
Thanks for helping!
Kind regards,
Unkown
Anonymous updated file attached with working buttons.
5 Replies
- Possibly two options
1. Create 2 visuals using 2 measures and hide/unhide them using bookmarks
2. Use a slicer instead of a button. You can create a measure that can use the slicer selection to dynamically filter the number of suppliers you want to show. Look at this post https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415 Anonymous thanks for sharing pbix but not very clear what you are actually looking?
Nishantjain thanks alot for your share your idea and maybe i need this one later ;D.
And additional if its not so a much work, could you make a sample in a new tab at my Sample1 File?
I think for other User would be great and for my too ( iam not so the power bi hero ;D)parry2k sorry for my late writing.
i have think about it and it right i did not describe it exactly: (BTW: i have updated the file)
So i have three buttons two of them have numbers, when you click of a button ( for example button with number 3) then you see only 3 suppliers( with ranking 1-3). Same thing when you click button with the number 6 you see only 6 suppliers ( with ranking 1-6)
The last button with the arrow reset the supplier table and show all values.
I hope i could explain it well. :)
Thanks for helping!
Anonymous updated file attached with working buttons.
