cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
windynan
Advocate I
Advocate I

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

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.

 
 

2021-06-23_9-37-14.png

 
 
 

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])))

2021-06-23_9-57-54.png

 

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

 

 

 

1 ACCEPTED SOLUTION

@windynan 

Check the attached file.

Fowmy_1-1624470875274.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

4 REPLIES 4
Fowmy
Super User
Super User

@windynan 

You use this technique to achieve TopN + Others

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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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. 

@windynan 

Check the attached file.

Fowmy_1-1624470875274.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!