cancel
Showing results for
Did you mean:
Member

## How to show top 10 cities with highest Sales?

Hi,

I have created a Dropdown filter on [Country] field and want to show top 10 cities in a bar chart. So I have created the a measure like below:

Top 10 Cities with highest profit = RANKX (ALL(Orders[City]),  CALCULATE(SUM(Orders [Profit])))

and city name should be shown at X axis and Profit will be at Y axis.

1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: How to show top 10 cities with highest Sales?

Hi,

First of all can you share me the mesare calculation with me?

My Fields are: [City], [Profit]

and also I have followed your instruction and have got the below chart:

But I want to arrange the city name like: City with Highest profit will show first and at last we can see the city name with lowest profit. So how can I achieve that?

4 REPLIES 4
Super User II

## Re: How to show top 10 cities with highest Sales?

1. Create a bar chart
2. Drop the City name in the Axis
3. Drop the profit in the value
4. Drop your rank measure in the Visual Level Filters area
5. Expand the visual level filter area for your city rank measure, then show it as less than or equal to, and type 10 in the box. Apply filter.

Proud to be a Super User!

MCSA: BI Reporting
Community Support Team

## Re: How to show top 10 cities with highest Sales?

Hi @dsandip59,

Hope this should be more clear.

For more details, you could have a reference of the attachment.

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

## Re: How to show top 10 cities with highest Sales?

Hi,

First of all can you share me the mesare calculation with me?

My Fields are: [City], [Profit]

and also I have followed your instruction and have got the below chart:

But I want to arrange the city name like: City with Highest profit will show first and at last we can see the city name with lowest profit. So how can I achieve that?

Highlighted
Member

## Re: How to show top 10 cities with highest Sales?

On your graph that you have attached, click on the 3 dots elipsis in the right top corner of the chart and select the order by Profit high to low.

Let me know how you get on.

Thank

shebr

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!