The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello
I am looking to see if there is a Power BI function that would allow the user to enter in a specific date to pull the data.
For example: My query has a date for "Report Date", and looking to see if there is a way to require the user to input a date for the data to pull. In Microsoft Access I would put in brackets [Enter Date] and a pop up would show asking the user to input a date. Wondering if Power BI has the same function.
Solved! Go to Solution.
Thank you for reaching out to the Microsoft forum community. Regarding your query about entering a specific date in Power BI, note that the feature to prompt users for a specific date (similar to [Enter Date] in Microsoft Access) is available only if your data source is in Direct Query mode.
You can achieve this by:
Power BI does not have a direct "pop-up input" feature like Microsoft Access does, but you can achieve similar functionality by using parameters or what-if parameters combined with a slicer or filter. Here's how you can replicate the behavior of prompting the user for a date:
If your data is in Import mode, direct prompts are not possible, but you can use the following alternatives:
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you
Hi @chrismoncrief
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi @chrismoncrief
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Thank you for reaching out to the Microsoft forum community. Regarding your query about entering a specific date in Power BI, note that the feature to prompt users for a specific date (similar to [Enter Date] in Microsoft Access) is available only if your data source is in Direct Query mode.
You can achieve this by:
Power BI does not have a direct "pop-up input" feature like Microsoft Access does, but you can achieve similar functionality by using parameters or what-if parameters combined with a slicer or filter. Here's how you can replicate the behavior of prompting the user for a date:
If your data is in Import mode, direct prompts are not possible, but you can use the following alternatives:
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you
Only possible if your data source is in Direct Query mode.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn