Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I'd like to be able to filter by a combination of controls at once. Is this possible?
For example, here's a page I'm working on:
I'd like to be able to click on a column in the team plot and a column in the year plot so that the data in the remaining plot is filtered by both. Currently when I click the second plot, the first filter is removed. Is this possible and if so how? I know that sliders kind-of give me that functionality but I'd like it directly from the plots.
@Mist I have been waiting for that long. Not possible at this stage by just clilcking on the visual.
However what you can do is drop fields from your team and year plots onto 'Report level filters' under 'Filters' section on 'Visualizations' pane. Doing this you will have forward and backward dependency. So when you select a value from first filter second filter will be updated and vice-versa and your plot / visual will display accordingly.
I could not get this to work @ankitpatira. Here's a snapshot of how I setup a (different) page with the Report level filters as suggested. Any idea what I've done wrong?
Thanks for the quick reply @ankitpatira. I'm not quite sure I understand but I will have a play with it and see.