Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'd like to create a combo chart to display quantity and market share of sold cars, split by brand and mark in each country.
I have one slicer for country, one for brand, one for make and one for cars sold/ Market share columns.
I don't know why but when I select a country, brand and make from the slicers, I can't use a combo chart to display market share and sold cars for each country, brand and mark. In other words, I can't attribute unit sold to "column values" and market share to "line values" of visualisations pane.
Region | Country | Brand | Mark | Clinder | Unit sold/Market share |
Sub-Saharan Africa | Mozambique | Audi | Q3 | 6 | 0.11 |
Sub-Saharan Africa | Mozambique | Audi | Q3 | 6 | 0.12 |
Sub-Saharan Africa | Mozambique | Audi | Q3 | 6 | 0.12 |
Europe | Bosnia and Herzegovina | Audi | Q5 | 6 | 0.12 |
Sub-Saharan Africa | Mozambique | Audi | Q3 | 6 | 0.15 |
Europe | Bosnia and Herzegovina | Audi | Q5 | 6 | 0.19 |
Europe | Bosnia and Herzegovina | Audi | Q5 | 6 | 0.23 |
Sub-Saharan Africa | Mozambique | Audi | Q3 | 6 | 0.23 |
Sub-Saharan Africa | Mozambique | Audi | Q3 | 6 | 0.33 |
Europe | Bosnia and Herzegovina | Audi | Q5 | 6 | 0.34 |
Sub-Saharan Africa | Mozambique | Audi | Q3 | 6 | 0.43 |
Sub-Saharan Africa | Mozambique | Benz | A | 6 | 0.43 |
Europe | Bosnia and Herzegovina | BMW | M3 | 6 | 0.45 |
Europe | Bosnia and Herzegovina | Audi | Q5 | 6 | 0.56 |
Europe | Bosnia and Herzegovina | Audi | Q5 | 6 | 0.67 |
Sub-Saharan Africa | Mozambique | Benz | A | 4 | 0.32 |
Europe | Bosnia and Herzegovina | Benz | C | 4 | 28006 |
Europe | Bosnia and Herzegovina | Audi | Q3 | 4 | 30823 |
Sub-Saharan Africa | Mozambique | Benz | A | 4 | 43489 |
Sub-Saharan Africa | Mozambique | BMW | Q7 | 6 | 48229 |
Sub-Saharan Africa | Mozambique | Audi | Q3 | 6 | 57698 |
Sub-Saharan Africa | Mozambique | Audi | Q3 | 6 | 59495 |
Sub-Saharan Africa | Mozambique | Audi | A3 | 4 | 67127 |
Europe | Bosnia and Herzegovina | BMW | M3 | 4 | 67603 |
Europe | Bosnia and Herzegovina | Audi | Q5 | 4 | 73876 |
Europe | Bosnia and Herzegovina | Audi | A3 | 4 | 81037 |
Sub-Saharan Africa | Mozambique | Audi | A4 | 4 | 88523 |
Europe | Bosnia and Herzegovina | Benz | A | 4 | 88857 |
Sub-Saharan Africa | Mozambique | BMW | M5 | 6 | 90850 |
Europe | Bosnia and Herzegovina | Audi | Q5 | 6 | 99741 |
Europe | Bosnia and Herzegovina | Audi | Q5 | 6 | 169624 |
Europe | Bosnia and Herzegovina | Audi | A4 | 4 | 236411 |
Hi @Q007 ,
You could use this combo visual --- line and clustered column chart.
And you could share some visual screenshots to show the issues.
Thanks,
I am affraid but it wasn't helpful as I see "column" on the legend which the key to my problem. Could you let me know how did you calculate it?
Hi @Q007 ,
The "column" is like your "market share". It is a column filled with some values. I put it to the "line values" as you mentioned in the question.
Thanks,
Actually I could duplicate sold cars and market share column and call the coppied column "market share", I should be able to solve the problem. Shouldn't I?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |