Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.