Funnel - filter does not work only highlight of current top 10 entries

[Patryk_PL_92]

Hi All,

I have a report where there is:
- Donut Chart - with categories

- Funnell Chart - showing top 10 companies by total amount they spent

When I try to filter Funnel Chart by clicking on each category in Donut Chart, it does not update the top 10 company names, it highlights from current list of top 10.

SELECTED YELLOW CATEGORY ON DONUT:

FUNNEL highlights some amounts which are connected with this category instead of showing me new top 10 from selected category:

This is a filter I have on Funnel Chart:

I want to see new top 10, from selected category.

Is that even possible, can someone advice on that?

[Patryk_PL_92]

Thanks, that works 🙂

[amitchandak · Accepted solution]

@Patryk_PL_92 , It should filter unless the interaction is off

Create a top 10 measure using TOPN with allselecected option and try

CALCULATE([Amount measure], TOPN(10,allselected(Table[Company]),[Amount measure],DESC),VALUES(Table[Company]))

https://databear.com/power-bi-dax-topn-function/

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...