cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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.

 

So any concept how to create this visualization? please help me.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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:Barchart.PNG

 

 

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?

View solution in original post

4 REPLIES 4
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

 

Hope this should be more clear.

 

Untitled.png

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.
edhans
Super User
Super User

  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.


Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Anonymous
Not applicable

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:Barchart.PNG

 

 

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?

View solution in original post

Hi @Anonymous

 

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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!