Power BI field parameters: let readers choose what a chart shows
Field parameters in Power BI let a reader change the measure or the dimension inside a visual by clicking a slicer. So one chart can show sales, margin or units, and one axis can switch from region to product. That saves pages and bookmarks. The feature is easy to set up, but it has documented limits. Below are the steps, good uses and the points to check.
- One visual, many views
- Reader picks the field
- Fewer pages to build
Last updated
What are Power BI field parameters?
A field parameter is a small table that lists fields from your model. The author puts that table into a visual instead of a fixed field. A slicer built on the same table then controls which field the visual uses.
The list can hold measures, dimensions or a mix of both, according to Microsoft's article. For example, a parameter might offer Revenue, Cost and Margin. Another might offer Country, Segment and Product.
Behind the scenes, Desktop writes the table in DAX. Each row has a display name, a reference to the field and a sort order. Therefore an author can edit the list later by changing that expression.
How to create Power BI field parameters
The whole setup takes a few minutes in Desktop, as long as your measures already exist.
Start a new parameter
First, open the Modeling tab, select New parameter and choose Fields. A dialog opens with your model's fields on the right.
Pick and order the fields
Then add the measures or columns you want to offer. Drag them into a sensible order and rename any that read badly.
Add the slicer
After that, keep the option that adds a slicer to the page. Desktop creates the parameter table and places the slicer for you.
Use it in a visual
Finally, drag the parameter into the axis or the values of a chart. Click the slicer and watch the visual change.
Where do field parameters work best?
They shine when several views differ by one field. Without the feature, an author builds a page per measure or hides visuals behind bookmarks. With it, one page does the job, so there is less to maintain.
They also help self-service. A reader who wants to see the numbers by segment does not need to ask for a new report. Instead, the choice is already on the page.
However, more choice is not always better. A slicer with fifteen options overwhelms people. So offer the handful of fields that readers truly compare, and leave the rest out. For help reworking a crowded report as a whole, see Power BI report redesign.
Limits of Power BI field parameters to know first
Microsoft documents these limitations, so check the current list before you commit to a design.
- AI visuals and Q&A do not support them
- Readers cannot pick a none option
- With nothing selected, all fields apply
- Implicit measures are not allowed, only explicit ones
- They cannot act as drill-through or tooltip link fields
- A live connection needs a local model to hold them
Do they replace bookmarks and measure switches?
Often they do. Before this feature, authors switched measures with a disconnected table and a SWITCH expression. That still works, but it only covers measures. A field parameter also changes the dimension, which the old trick cannot do.
Bookmarks remain useful for other things. For example, they show and hide whole groups of visuals or reset filters. So the two tools solve different problems and often sit on the same page.
Formatting is one thing to watch. When measures with different formats share a visual, check that axis labels and titles still make sense. A dynamic title that names the selected field helps readers stay oriented.
Questions about Power BI field parameters
Can Power BI field parameters mix measures and dimensions?
Yes. Microsoft's article says a parameter can hold different measures and dimensions together. In practice, most authors keep them apart, because a mixed list is hard to explain in a slicer. So build one parameter for the measure choice and another for the axis choice. Readers then see two clear controls.
Do field parameters work with a live connection?
Not with a pure live connection, since the parameter table needs a local model. Microsoft notes that you can use them when you connect through DirectQuery to a Power BI semantic model or Analysis Services. Alternatively, ask the model owner to add the parameter to the shared model. Then every report on it can use the same list.
Why do I need explicit measures for a parameter?
A field parameter refers to fields by name, and an implicit measure has no name in the model. Microsoft therefore lists implicit measures as unsupported. The fix is simple. Write a short DAX measure, such as a sum of the column, and add that instead. Explicit measures are good practice in any case.
Can I edit Power BI field parameters after creating them?
Yes. Select the parameter table and edit its DAX expression in the formula bar. Each line holds a display name, a field reference and an order number. So you can add a field, rename one or change the sequence. Afterwards, check every visual that uses the parameter, because a removed field changes what readers see.
Can you simplify a report that has too many pages?
Yes. We rebuild crowded reports with field parameters, drill-through and cleaner layouts. We are a division of Sataware Technologies and independent of Microsoft. The service runs online inside your own tenant, with a demo each week. Book the free 30-minute assessment, and we reply within 2 hours.
Let's build your first dashboard together.
Tell us what you report on today. A consultant replies within 2 hours with next steps.
Trusted partners
Microsoft Solutions Partner · AWS Partner
Cloud & AI Platforms
Azure SQL, Microsoft Fabric and the data pipelines behind your reports.
AI Business Solutions
Power BI reporting on your Dynamics 365, Business Central and Power Platform data.
Security
Row-level security and Entra ID sign-in on every report and workspace.
Amazon Web Services
Power BI on your AWS data, with connectors for Redshift, Athena and S3.