cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
megan2010 Frequent Visitor
Frequent Visitor

Presenting data in ranking and its percentage in total

Hi, I want to visualise my data in in TopN format. I want want to rank Top 5 Company by is sum of its sales in each class.

Sample data.JPG

Since there are lots of different companies in my data, I only want to show top five company in my visual but still show its percentage in based on total sales.

If I filter it by top N to show top5 the visual add up to 100% with just top5 companies therefore its actual percentage of the sale changes.

I want to display the ranking of the companys by each classes and present data in right percentage.

 

Hope it make sense. Thanks

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Presenting data in ranking and its percentage in total

Hi,

 

You may download my PBI file from here.  Since your data is very less, i have show Top 2 Companies in every Class.  The % is calculated as the total revenue of all companies in the Class (see Class 7).

 

Hope this helps.

 

Untitled.png

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Presenting data in ranking and its percentage in total

Hi,

 

Please show the expected result.

megan2010 Frequent Visitor
Frequent Visitor

Re: Presenting data in ranking and its percentage in total

Hi Ashish, below is the type of representation I want. so it shows top5 comanies each class  and its market share.

 

Sample data2.JPG                                                                                 

Thanks

Highlighted
Super User
Super User

Re: Presenting data in ranking and its percentage in total

Hi,

 

You may download my PBI file from here.  Since your data is very less, i have show Top 2 Companies in every Class.  The % is calculated as the total revenue of all companies in the Class (see Class 7).

 

Hope this helps.

 

Untitled.png

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 503 members 4,308 guests
Please welcome our newest community members: