chart to show product sales in 2 cities

[Anonymous]

dear all

i have this chart which contain the sales of product and for 2 cities.

Is there a way to show both the sale of the products in both the cities?

in my actual case, i have up to 100 diffferent products.
Any idea how it can be done?

thank you very much.

[armely]

Have you tried using column chart to see if it will get the job done?

[Anonymous]

@armely 
yes...but it not showing the 2 city in 2 bars.
what i am trying to achieve is the chart of the 2 cities side by side

[armely]

To make sure I got this right, you want to show the cities, product and their respective numbers on the same chart?

[Anonymous]

@armely 

yes, you are right...but 1 challenge is that i have up to 100 products.
I tried using switch but it too many products.

[armely]

Let's step back a bit, what business question are you trying to answer? You maybe best served with two charts rather than one.

[Anonymous]

in my case, my managment want to see the sale of products (example Product A) in both our shop locations.
example This product is newly launch.

I am also providing in 2 charts but wonder if possible to be in 1 chart.

@armely 

[armely]

With Power BI reports being interactive, would they be ok with two charts? One for products and one for cities, when they click on a products say productA, you can show the numbers for each city. You can also change how the interaction behaves.

[Anonymous]

@armely 
I am just exploring various ways to present the chart, so was wondering if it is possible to do so.

Was it too tedious or not possible to do in such way?

[armely]

Combining them will not answer the question since they are two independent variables. Try two chart with different interactions
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions