Dynamic top 10 Amount vs the rest in the same stacked bar chart

[windynan]

Hi All - I am trying to create something like below. A stacked bar chart that shows the top 10 sum value vs the rest sum value. The top 10 selection will be dynamic because there's a time period filter applied.

I tried to create a rank for each row within the selected period, then also created a new measure - Category top 10 based on the rank but it's not working because I can't drag this new field to seperate the top 10 portion from the bar chart. Any idea?

Rank =

RANKX (ALLSELECTED('Reporting'),CALCULATE(SUM('Reporting'[Amount])))

My data looks like this:

ID   Amount   Date

1   3            3/1/2021

2    65          3/14/2021

3    234        2/1/2021

4    345        2/5/2021

5    564        6/3/2021

6    64         7/3/2021

7    45         8/3/2021

8    11

[Fowmy]

@windynan 

You use this technique to achieve TopN + Others

https://blog.gbrueckl.at/2019/05/power-bi-dynamic-topn-others-with-drill-down/

[windynan]

Hi Fowmy - this is not what I am looking for. The link you mentioned are not stacked bar chart. I am looking for a way to stack top N and others amounts in one bar, not seperate bars. 

[Fowmy · Accepted solution]

@windynan 

Check the attached file.

[windynan]

Thankssss!!! This is exactly what I was looking for.