cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lsutrey
New Member

Visual control of a filter

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!

1 ACCEPTED SOLUTION
chrisu
Responsive Resident
Responsive Resident

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/

 

View solution in original post

1 REPLY 1
chrisu
Responsive Resident
Responsive Resident

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/

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors