How to make a combo chart using two set of values of only one slicer

[Q007]

Hello,

I would like to use the values of one column of a table to make a combo chart (stack bar and line). In the table attached, I'd like to use both unit sold (Stackbar) and market share (line) for all countries using  unit sold/marketshare column.

THanks for your tie in advance

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

[v-frfei-msft]

Hi @Q007 ,

Sorry I cannot get you. Could you please share more details about What is your excepted result?

[Q007]

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.

[v-frfei-msft · Accepted solution]

Hi @Q007 ,

Is that your excepted result?

Btw, pbix as attached.