Forum Discussion
Filteration based on same datasource
Hello
I have two graphs from same data source
Graph A has brand with total sale of year
Graph B has Products of the brands with total sales of year
When ever i click on the brand of Graph A the graph B starts showing blank. However if a giver a slicer to graph B and select same brand then the graph B gets filtered out.
Is their a way where Chossing the brand from Graph A filters data on Graph B too.
Interactive visuals does not seem to work on data from same source
1 Reply
Hi Anonymous ,
There is a way to make Graph B filter based on the selection made in Graph A. You can use the "Sync Slicers" feature in Power BI to achieve this.
First, create a slicer for the brand field in your data source and add it to both Graph A and Graph B. Then, select the slicer in Graph A and click on the "Sync Slicers" button in the Visualizations pane. This will open the Sync Slicers pane.
In the Sync Slicers pane, select the slicer you just created and click on the "Apply to" dropdown. From here, you can select the slicer in Graph B and click on "OK". This will sync the slicer between both graphs, so that selecting a brand in Graph A will also filter the data in Graph B.
Note that this will only work if both graphs are using the same data source and the same field for the brand. If you're still having issues with the data not filtering properly, you may need to check your data model or ensure that the slicer is set up correctly.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quick