Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Filtering by columns rather than values

Let's say I have 3 categories: population, average height, average weight, for every county in New York. Each category contains different data points - for instance, Westchester County might have 3 mil population, 66 in average height, 120 average weight.

 

Next, let's say I display a shape map of New York counties. How do I create a visualization that filters based on a category rather than a data point? For instance, if I click "population" as a check-box, I should see color saturation, or a graph based on the population across these districts.

Right now, I am only able to click different districts' population, whether that's 3 million, 10 million, .5 million, etc..,

In other words, y'all see the "fields" block on the right? How do I create something like that within the visualization itself?

 

Thanks!

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Not very clear, Do you want to change color saturation based on the selected measure. Then you need a measure slicer and use that measure(slicer measure) in color saturation

 

refer if needed

 

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Let's say I have a checkbox with different categories, which correspond to Excel columns. If I check a certain category - say population - I should be able to see color saturation in the NY county based on population.

Does that make sense? If so, can you help with this?

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.