Forum Discussion
Power BI Report Builder
Hi, lynnma
Let's follow my example to learn how to use parameters to filter datasets:
First, here's my dataset:
Method 1: Create a parameter based on the cource name:
An important step is to apply this parameter to dataset1:
The results are as follows:
Method 2, pass the parameters in the query:
The results are as follows:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi lynnma
To create a physician contact information report in Power BI Report Builder with a parameter for selecting a physician’s name, follow these steps carefully. First, ensure you have a dataset that retrieves distinct physician names, which will be used to populate the parameter dropdown. Then, create a report parameter named SelectPhysName and set its available values to come from this dataset, ensuring it is a single-selection text parameter. Next, modify the main dataset query to include a WHERE clause that filters records based on the selected physician’s name, using @SelectPhysName as the SQL parameter. After that, go to the dataset properties and correctly map the report parameter to the query parameter to ensure filtering works as expected. If you encounter the "ExecuteReader: CommandText property has not been initialized" error, verify that your dataset query is properly assigned and includes the WHERE clause with the parameter. If you receive the "Forward dependencies are not valid" error, check that your parameter does not have a circular dependency in its available or default values. By following these steps, the report should correctly filter and display only the selected physician’s contact information.