Forum Discussion
Solved
Filtering with map visual
Hi, please can anyone help me? I need to filter a top 5 rank chart bar by using a map visual (Brazil - States). My model is simple, it contains: - a databse with 5 columns: Brazil state, Product ...
- You should be able to do this using "Edit Interactions" and set the bar chart to filter.
riadorra , Not very clear to me .
You can top 5 product sold like
rankx(all(Table[product]) calculate(Sum(table[ammount sold ])))
You can visual level filter of bar visual
or you can use TOP N
https://blog.gbrueckl.at/2019/05/power-bi-dynamic-topn-others-with-drill-down/
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415