Interactive Dashboard between tree map and donut - visualizing and drilling on multiple columns

[Anonymous]

Hi Guys

I am new to Power BI and I am trying to learn by analyzing some US FBI Crime data and I got stuck badly. I have a table called Robbery that includes fields like State, Robbery Rate, Firearms rate, knives rate, strong arms rate, other weapons rate.  I have more tables like murder, aggravated assault which have similar columns with values related to that particular crime.

Robbery rate column is related to values in the Firearms rate, knives rate, strong rate columns arms rate, other weapons rate columns.

I want to show a tree map or a donut that has high level crime rate such as Robbery rate, murder rate and aggravated assault rate.

And when i click on the particular segment, i want to see the corresponding Firearms rate, knives rate, strong arms rate, other weapons rate based on the selection ( Robbery rate, murder rate and aggravated assault rate).

I tried created a hierarchy but it only shows me one level at a time but i want to see  (Firearms rate, knives rate, strong arms rate, other weapons rate) in one level.

Some thing like in the picture below. If i click on Robbery rate on the tree map, i want to be able to see the donut with the weapons related to the Robbery on tree map for that particular state.

Please guide me how i can go around solving this?

Any help will be appreciated.

[Anonymous]

@Anonymous 

You cannot do that in power bi, Power bi cannot automatically analyze the weapons words and assign them to a crime type. What I am thinking is before power bi visuals, you should at least have a table that categorize those weapons to crimes. 

Regards
Paul