Superimpose line chart on a column chart

[kjani]

I am a beginner with Power BI Desktop. Here is my dataset. I want to build two charts imposed on each other where Scenario version A is shown as a column chart and Scenario version B is shown as a line chart. I want to be able to filter by Customer, by State and by Name. Thank you so much in advance.

Customer ID	Customer Name	State	Scenario	Name	20_01	20_02	20_03	20_04	20_05	20_06	20_07
123	Cust A	CA	Version A	Gross Rev	50	45	40	35	30	30	30
123	Cust A	CA	Version A	Gross Profit	10	9	8	7	6	6	6
567	Cust b	GA	Version A	Gross Rev	100	90	80	70	60	60	60
567	Cust b	GA	Version A	Gross Profit	20	18	16	14	12	12	12
123	Cust A	CA	Version B	Gross Rev	80	76	60	40	40	40	40
123	Cust A	CA	Version B	Gross Profit	20	19	15	10	10	10	10
567	Cust b	GA	Version B	Gross Rev	40	36	32	20	20	20	20
567	Cust b	GA	Version B	Gross Profit	10	9	8	5	5	5	5

[v-eachen-msft]

Hi @kjani ,

You could unpivot the value columns in the query editor.

And it is easier to create the charts you want.

[parry2k · Accepted solution]

@kjani see attached, assuming that's is what you are looking for?