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
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

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!