I've created a tool to determine specific Census data based on Parish (county), Tract and Block Group. It's goal is to allow a user to select a specific location and know the population, income levels and race/ethnicity demographics. The data set is HUGE. I used slicers to make selections and thought it was working fine but realized later that when using multi-select it wasn't differentiating between selections. Let me see if I can explain. Here is overall look:
Full.png
In second picture you can see that I selected Acadia, Tract #960400 Block Group 2. This displays as it should.
first.png
In the third pic you will see that Acadia, 960400 and 961000, 2 and 7 are selected. The problem is that it is showing a total for all of those things at once. I WANT to show only total for Tract#960400, Block Group 2 + Tract#961000, Block Group 7.
second.png
I understand WHY this is happening b/c a filter of a singular data source can only do so much but I'm wondering if there is a simple way to achieve my desired result without creating 100's of data sets with a Slicer from each. This is for the entirety of Louisiana so there are thousands of permutations of Parish(county), Tract, Block Group. I am not a super user and know almost nothing about macros and coding so I was hoping there was a simpler answer.
Thanks in advance for any advice.
Bookmarks