Forum Discussion
Helper VHow to dynamically filter a chart in Power BI Report Builder
Hi all!
I've a report in Power BI Report Builder that uses a Power BI semantic model as its data source.
I need to create filters and charts/tables to allow users to filter the data. However, I'm unable to link the filters to the visual objects. Can anyone help me?
Thank you.
Hi Fern_21,
Thank you for reaching out to Microsoft Fabric Community.
Power BI Report Builder (Paginated Reports) does not support slicers or visuals that auto update based on selection like in the desktop. And also when using power bi semantic models as the source it cannot be directly filtered with typical query parameters. To filter data dynamically please follow below steps:
- Create a report parameter like for example Region.
- Create a Dataset using a DAX query and use that parameter inside the query.
- Create a chart or table and bind it to this dataset.
When the user selects a value for the parameter, the dataset will return filtered data accordingly and the visuals will reflect that data.
If this post helps in resolving the issue, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
5 Replies
v-achippaCommunity Support
Hi Fern_21,
Thank you for reaching out to Microsoft Fabric Community.
Power BI Report Builder (Paginated Reports) does not support slicers or visuals that auto update based on selection like in the desktop. And also when using power bi semantic models as the source it cannot be directly filtered with typical query parameters. To filter data dynamically please follow below steps:
- Create a report parameter like for example Region.
- Create a Dataset using a DAX query and use that parameter inside the query.
- Create a chart or table and bind it to this dataset.
When the user selects a value for the parameter, the dataset will return filtered data accordingly and the visuals will reflect that data.
If this post helps in resolving the issue, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
- Ilgar_Zarbali
Super User
Power BI Report Builder doesn't support slicers or direct interactivity like Power BI Desktop.
To Dynamically Filter a Chart:
1. Use Parameters Instead of Slicers:
- Right-click on the dataset - Dataset Properties - Add a query parameter (e.g., region).
- Create a Report Parameter (same name as query parameter).
- Set available values using a separate dataset (e.g., list of regions).
2. Apply Parameter to Filter Dataset:
- Modify your DAX query to use the parameter:
EVALUATE FILTER ( YourTable, YourTable[Region] = region )3. Link Parameter to Visuals:
- Charts and tables will use the filtered dataset and auto-update based on parameter selection.
This allows users to filter the report dynamically via dropdowns at the top of the paginated report.
If this helped solve or clarify your issue, please mark as solution and give kudos.
v-kathullacHi @Fern_21,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
Thanks
