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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

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!