Forum Discussion
Helper IIIHow to create user input parameters in power bi desktop?
Hi JaipalAnu ,
It's hard for me to provide you with a detailed and precise solution just by words, please provide me with some sample data or a screenshot of the data model, thank you!
In addition, if you want to use parameter to achieve the filter, you need to create a relationship between the parameter and the table you need to be filtered after you create the parameter, or you can create a slicer, which can also achieve the function of the parameter.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IIIHi, Thanks for your reply!
I have created a view, it has transaction data and not able to load complete data into the power bi and it was taking very long time due to huge records, so we are planning is to load the data based on parameters.
Ex: Ship To Number field and Processed Date field is there in the report, user will select any SHip To Number on any dates then they will get that particular SHip To Number data on the dates they selected.
Can we achieve this in the power bi report, using import or direct query? If yes please provide me any sample report or any guidence.
Thanks