Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

How to use 'List of Values' from parameters in PowerBI Service or Select multiple values.



We created a report with a few parameters, some of them are date values and some are text. For text type, we want to use 'List of values'. We could select the required values from the list on the power bi desktop. Is there any option or workaround to see the list of values and choose the required one in Power bi service? And we would like to know if we can pass multiple values for the same parameter in Powerbi service. 



Thanks in advance.

Responsive Resident
Responsive Resident

Yes, you can see the list of values and choose the required ones for a text parameter in Power BI Service. Here's how you can do it:

  1. Open your report in Power BI Service and go to the report page that has the parameter you want to modify.
  2. Click on the ellipsis (...) next to the report name and select "Settings" from the dropdown menu.
  3. In the "Settings" pane, select "Parameters" from the left-hand menu.
  4. Click on the parameter you want to modify and select "Edit" from the dropdown menu.
  5. In the "Values" section, select "List of values" and enter the values you want to include in the list, separated by commas.
  6. Save the changes to the parameter and refresh the report page to see the updated list of values.

Regarding passing multiple values for the same parameter in Power BI Service, yes, it is possible. Here's how you can do it:

  1. In the "Values" section of the parameter settings, select "Allow multiple values" checkbox.
  2. Save the changes to the parameter and refresh the report page to see the updated parameter behavior.
  3. When running the report, you can select multiple values for the parameter by holding down the "Ctrl" key and clicking on each value you want to include, or by selecting a range of values with the mouse cursor.

Note that the behavior of multiple value parameters may vary depending on the data source and visualization type you are using. Some visuals may not support multiple value parameters, while others may require additional configuration or filtering to display the correct results.

Super User
Super User

You can do all this but you have to invest extra effort in your Power Query to distinguish between single items and lists.

One example is here: Passing Any Arbitrary Value From A Power BI Report To A Dynamic M Parameter (


Hey lbendlin,


Thanks for the response, we have tried the example provided. The main purpose of our requirement is when we share our report with end users through a public link, they should be able to pass the desired value and filter the data based on that. However, using parameters only the report owner will have the option to pass the value to parameters. And we have huge data so we cannot load the entire data and later use slicers to filter. Kindly suggest any other option to achieve this.


Thank you.


The example I linked to allows report users to influence the Direct Query queries. Where have you observed the "report owner" restriction? 


BTW, "report owner" is not a thing.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors