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
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.
Good Morning,
Thank you very much for the feedback. I figured it out late afternoon yesterday. The sources I was reading and viewing did not mention creating a second data set for the parameter. This is the major piece I was missing. The difference between what you posted verses what I completed is I did not create the param in the sql code and setting a condition in the WHERE clause. I got it to work correctly without having to complete that part. However, I did create a second data set and called DataParameter, then proceeded on building out the parameter.
I will "Accept as Solution" what you have provided. Thank you again for responding back promptly!
Very Appreciative,
Mark Lynn.