Pulldown Menu

Hi, Hakko2024 

I create a sample table:

Then Importing data sets

In Power BI Report Builder, right-click Parameters and select Add Parameter. Set the parameter name to CertifierName.

Also make sure that the parameter doesn't depend on itself, and in the parameter properties, make sure that the Available Values tab isn't set to depend on the Dataset1 value. You need to create another DataSet2 dataset, just like the first dataset. Then let the argument reference the content in DataSet2

In Report Designer, add a text box that displays the selected name. Set the expression for the text box to:

=Parameters!CertifierName.Value

Select Run, when you select Parameter, the text will show what you choose, here is my preview

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, Hakko2024 

You can use the table visual directly. I've added the relevant data you mentioned to the original data, which is my current example table.

To create parameters, you can create them in DataSet1. Go to Query Design and create a filter with the Parameter option ticked.

Change the parameter setting to DataSet2.

Then you just need to create a Table visual, then pull your fields in and hit run. Selecting a parameter displays information about that user.

You can learn more from the following links:

Build a Query in the Relational Query Designer (Report Builder and SSRS - SQL Server Reporting Services (SSRS) | Microsoft Learn

Tutorial: Create a basic table report (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Learn

Report Builder tutorials - SQL Server Reporting Services (SSRS) | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.