formula driven dropdown

[Jackparton]

Good afternoon, i have a drop down cell in my excel that drives the formulas in the rest of the sheet however when i pull it into Power BI the dropdown isnt there. for exaple i want a slicer with numbers 1-10 and that slicer will drive the variables in my dashboard. please advise. Thank You! 

[amitchandak · Accepted solution]

@Jackparton , Based on what I got.

you can use numeric parameters

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ