Forum Discussion
Filtering with map visual
- You should be able to do this using "Edit Interactions" and set the bar chart to filter.
Hi,
i´m sorry, maybe i didn't explain the isse rigth. I'll try to give you an example ...
What is happening is when there is no area selected on the map, the top five produts shows on the bar chart are:
1 - Strawberry (200 produtcs sold)
2- Mango (98 products sold)
3 - Pineaple (70 products sold)
4 - Banana (60 products sold)
5 - apple (50 products sold)
By clicking at Sao Paulo on the map, the bar chart only highlights / change the ammount of the products sold. What i need is that by clicking on Sao Paulo, for example, the chart shows the top 5 products in Sao Paulo, and as a result the chart should shows:
1 - Strawberry (80)
2 - Pienaple (60)
3 - Orange (35)
4 - Apple (30)
5 - Grape (10)
Thank you
Riad
riadorra - AllisonKennedy was correct, you need to change the filter behavior to Filter instead of Highlight:
- Thanks Greg_Deckler for the photo support - a picture really is worth a 1000 words.
riadorra here is a link also on the feature we are recommending: https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Hopefully that helps clarify how this could fix your query, if still unclear, come back with more questions and detailed info of what happens when you try our suggestion.
Cheers!
