topic Re: Top N with all option in parameter in DAX Commands and Tips

Top N with all option in parameter

Anonymous — Tue, 30 Mar 2021 09:41:27 GMT

Can anyone tell me how to show Topn parameter with all option...

example suppose i have 200 vendor and their sales amount , now i have a topn drop down parameter

where the option will 5, 10, 20, 25, all...

So if user select any number like 5, 10,20, 25.. thos top values will be shown otherwise if the the user select all option all 200 vendor data will be there in the chart..

I have already implemented top N parameter but i can't add all option in parameter as in power bi paraameter option is only

whole, decimal and fied number in the option..PLease help

Re: Top N with all option in parameter

amitchandak — Tue, 30 Mar 2021 09:39:56 GMT

Anonymous , refer for Top N with Others
https://www.youtube.com/watch?v=UAnylK9bm1I
https://blog.gbrueckl.at/2019/05/power-bi-dynamic-topn-others-with-drill-down/

Re: Top N with all option in parameter

Anonymous — Tue, 30 Mar 2021 09:42:29 GMT

hI Amit,

i dont need other option.. i need parameter selection with all option.. so that user can select all the data at one go

Re: Top N with all option in parameter

Anonymous — Tue, 30 Mar 2021 09:43:43 GMT

Other option is catagorizing the data but user want to see all the vendor details , their names and sales once it selects All from parameter

Re: Top N with all option in parameter

Jihwan_Kim — Tue, 30 Mar 2021 11:03:10 GMT

Hi, Anonymous

Please correct me if I wrongly understood your question.

Instead of using NewParameter Function in the Modeling Menu tab, how about just creating one-column table that contains 5,10,15,20,25. When you add this column into the slicer visualization, I think you can disable or able to show Select All, like below picture.

I think from here you can create related measures to show visualizations dynamically.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

Re: Top N with all option in parameter

Anonymous — Wed, 31 Mar 2021 10:35:29 GMT

Hi...

If i select all.. it will select all the option in parameter like 5, 10, 20, 25,30 .. but i want to see the other 100 vendors value... as the total vendor are 200.. now i have topn parameter which help the user to select upto top 25 vendors.. but if the vendors want to see the data for all the 200 vendors in the chart..In your solution i have created same, a table containing values like 5, 10, 20.. but if we select all in the slicer it will show the vendors for all the selected values ( that is upto 30) not the underling 170 vendors

Re: Top N with all option in parameter

Jihwan_Kim — Wed, 31 Mar 2021 10:56:25 GMT

Hi, Anonymous

Thank you for your feedback.

What I meant was,

if countrow(slicer table) = 1 -> then based on the selectedvalue (slicer) -> perhaps you can create corresponding ranking show.

if countrow(slicer table) <>1 -> then show all vendors.

if it is OK with you, please share a sample pbix file, then I can try to come up with more accurate measures.

Thank you very much.

Re: Top N with all option in parameter

Anonymous — Wed, 31 Mar 2021 12:13:12 GMT

ok.. but how to insert 'All' as a option to the parameter like 5,10, 15,,25,30, All

so that when user select All, all the vendor name that is 200 will come

Re: Top N with all option in parameter

Jihwan_Kim — Wed, 31 Mar 2021 12:22:31 GMT

Hi,

Thank you for your feedback.

My suggestion was a kind of alternative because I could not find a way to insert "ALL" into the parameter with numbers. But I still think showing a word like "Select all" in the slicer is a good alternative.