Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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?
Hi @Anonymous,
Hope this should be more clear.
For more details, you could have a reference of the attachment.
Best Regards,
Cherry
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi,
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |