Button/Filter | Button trigger and filter values

[Anonymous]

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

[Nishantjain]

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/3...

[parry2k]

@Anonymous thanks for sharing pbix but not very clear what you are actually looking?

[Anonymous]

@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!

[parry2k · Accepted solution]

@Anonymous updated file attached with working buttons. 

[Anonymous]

@parry2k  thanks a lot 🙂