Power BI Visualisation Filter issue

[spycein]

Hi Everyone,
I Have a following table from which i created my Power BI Dashboard.

[TABLE="width: 207"]
<tbody>[TR]
[TD]Table:-1

City[/TD]
[TD]Product[/TD]
[TD] Revenue[/TD]
[/TR]
[TR]
[TD]Mumbai[/TD]
[TD]Desktop[/TD]
[TD="align: right"]953774[/TD]
[/TR]
[TR]
[TD]Mumbai[/TD]
[TD]Keyboard[/TD]
[TD="align: right"]793440[/TD]
[/TR]
[TR]
[TD]Chennai[/TD]
[TD]Laptop[/TD]
[TD="align: right"]391087[/TD]
[/TR]
[TR]
[TD]Kolkata[/TD]
[TD]Mouse[/TD]
[TD="align: right"]188533[/TD]
[/TR]
[TR]
[TD]Delhi[/TD]
[TD]Keyboard[/TD]
[TD="align: right"]943413[/TD]
[/TR]
[TR]
[TD]Mumbai[/TD]
[TD]Laptop[/TD]
[TD="align: right"]317314[/TD]
[/TR]
[TR]
[TD]Chennai[/TD]
[TD]CFL[/TD]
[TD="align: right"]157082[/TD]
[/TR]
[TR]
[TD]Mumbai[/TD]
[TD]LED Tube[/TD]
[TD="align: right"]623460[/TD]
[/TR]
[TR]
[TD]Chennai[/TD]
[TD]LED Bulb[/TD]
[TD="align: right"]429271[/TD]
[/TR]
[TR]
[TD]Mumbai[/TD]
[TD]CFL[/TD]
[TD="align: right"]532723[/TD]
[/TR]
[TR]
[TD]Kolkata[/TD]
[TD]LED Tube[/TD]
[TD="align: right"]225756[/TD]
[/TR]
[TR]
[TD]Delhi[/TD]
[TD]LED Bulb[/TD]
[TD="align: right"]523654[/TD]
[/TR]
[TR]
[TD]Kolkata[/TD]
[TD]CFL[/TD]
[TD="align: right"]179843[/TD]
[/TR]
[TR]
[TD]Delhi[/TD]
[TD]CFL[/TD]
[TD="align: right"]521181[/TD]
[/TR]
</tbody>[/TABLE]

Table:- 2

[TABLE="width: 144"]
<tbody>[TR]
[TD]Category[/TD]
[TD]Product[/TD]
[/TR]
[TR]
[TD]Electronics[/TD]
[TD]Desktop[/TD]
[/TR]
[TR]
[TD]Electronics[/TD]
[TD]Keyboard[/TD]
[/TR]
[TR]
[TD]Electronics[/TD]
[TD]Laptop[/TD]
[/TR]
[TR]
[TD]Electronics[/TD]
[TD]Mouse[/TD]
[/TR]
[TR]
[TD]Electrical[/TD]
[TD]CFL[/TD]
[/TR]
[TR]
[TD]Electrical[/TD]
[TD]LED Tube[/TD]
[/TR]
[TR]
[TD]Electrical[/TD]
[TD]LED Bulb[/TD]
[/TR]
</tbody>[/TABLE]

I Have created a dashboard contains three visuals.

One Category wise Sale Visualisation, product wise sale visualization and a map visualisation.

When i select a city on the map visual the category wise and product wise visuals get filtered. But when i select the category to see the product wise sale visual for that particular city then the filters get removed and the data related to that category get filter and show up on both the other visuals i.e. Map and Product wise sale visuals.

For example from the above table example,

I need to show Mumbai city ( from Map Visual) Category wise sale report. If i select Mumbai then on the Category visualisation should be shown values pertaining to Mumbai only and then when i select particular category on that visual, the product sale visual report should show sale report pertaining to mumbai only.

[/URL][/IMG]

Hope i made my points clear. Requesting you kindly help me on this.

Regards

Shib.