Forum Discussion
Solved
ReportEmbed URL filters not working for Field Parameters
Hi, I am trying to pass filters for field parameters Dimension and Metrics but filters are not applied properly App.powerbi URL -> &filter=Dimension/Dimension%20in%20('subcat_name'%2C'pmcat_na...
Hi Ashish29,
Why does it work in the Power BI App but not in Embed?
- Field Parameters are implemented as calculated tables with DAX behind the scenes.
- When you pass multiple values in the filter via URL, Power BI Service (App) interprets them correctly because it uses the full report context.
- In Embed scenarios, the filter syntax is applied at the dataset level, and Field Parameters do not behave like normal columns—they are dynamic selections. As a result:
- For one parameter (Metrics), the filter works because the engine resolves the mapping.
- For the other (Dimension), only the last value is applied because the parameter table does not support multi-select via URL in embedded mode.
Is this expected?
Yes. Currently, URL filters do not fully support multi-select for Field Parameters in embedded reports. This is by design because Field Parameters are not standard fields—they dynamically swap columns in visuals.Workarounds
- Use a slicer in the report for Field Parameters
Instead of relying on URL filters, expose slicers for Dimension and Metrics. This ensures proper multi-selection. - Switch to standard columns for filtering via URL
If you need URL-based filtering, consider using actual columns (not Field Parameters) for Dimension and Metrics filters.
Official References:If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
Zanqueta
Super User
Super UserHi Ashish29,
Why does it work in the Power BI App but not in Embed?
- Field Parameters are implemented as calculated tables with DAX behind the scenes.
- When you pass multiple values in the filter via URL, Power BI Service (App) interprets them correctly because it uses the full report context.
- In Embed scenarios, the filter syntax is applied at the dataset level, and Field Parameters do not behave like normal columns—they are dynamic selections. As a result:
- For one parameter (Metrics), the filter works because the engine resolves the mapping.
- For the other (Dimension), only the last value is applied because the parameter table does not support multi-select via URL in embedded mode.
Is this expected?
Yes. Currently, URL filters do not fully support multi-select for Field Parameters in embedded reports. This is by design because Field Parameters are not standard fields—they dynamically swap columns in visuals.
Workarounds
- Use a slicer in the report for Field Parameters
Instead of relying on URL filters, expose slicers for Dimension and Metrics. This ensures proper multi-selection. - Switch to standard columns for filtering via URL
If you need URL-based filtering, consider using actual columns (not Field Parameters) for Dimension and Metrics filters.
Official References:
If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.