Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Is it possible for a visual to affect what is displayed in a filter? Here's the scenario - I have a bar chart of various data points broken down by State. I have other visuals on the report, and they react just fine when I click one of the states in the bar chart. I also have a couple of filters on the report. The filters are not affected when I click a state in the bar chart. In other words, I have a filter for state and a filter for city - they continue to show the same values regardless of what is selected in the visualization. I don't want to have a visual by the city - it's too busy. I'd like the filter for the city to only display the cities in the state that was selected in the bar chart, and then if you want to see each individual city's numbers, you can use the filter for that to affect the bar chart. When I click the state in the bar chart, the city filter continues to show every city in the dataset. The only way to cull down the cities listed in the city filter is to add a state filter and click the state in it - takes up valuable real estate on the page and makes the user make an extra click. Any suggestions?
Thanks!
Solved! Go to Solution.
I can think of two options to accomplish what you want:
1. Add cities as a slicer instead of (or in addition to) a filter. That will get cities onto the report Canvas and will interact with your other visuals. See https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-slicers/
2. Add cities underneath states in your bar chart to create a drill-down. That will allow you to drill into each state and see the cities underneath them from within the bar chart. See https://powerbi.microsoft.com/en-us/documentation/powerbi-service-drill-down-in-a-visualization/
I can think of two options to accomplish what you want:
1. Add cities as a slicer instead of (or in addition to) a filter. That will get cities onto the report Canvas and will interact with your other visuals. See https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-slicers/
2. Add cities underneath states in your bar chart to create a drill-down. That will allow you to drill into each state and see the cities underneath them from within the bar chart. See https://powerbi.microsoft.com/en-us/documentation/powerbi-service-drill-down-in-a-visualization/
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
34 | |
21 | |
20 | |
14 | |
12 |
User | Count |
---|---|
20 | |
19 | |
18 | |
13 | |
13 |