Forum Discussion
Jackparton
2 years agoNew Member
formula driven dropdown
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!
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
1 Reply
- amitchandakSuper User
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