Combo Chart secondary chart line series not only column series

[dobregon]

Hi

I have a doubt about chart lines, combo charts, etc. In reallity i want to have a visual that can put lines in 2 y-axis. I see the power KPI visual but it doesn't work

As an example this is what i have

It is a only one line (expected per product type) and multiple columns (one per product inside the product type analysis). The problem that i have is in this visual the only way to put all my products is to use combo chart and putting column series but that i really want is to have the column as the expected (only one column) and the line series.

I know the solution of create each measure of lines and put lines and lines, but the problem is that inside a product type i can have 2-20-50 different products so it needs to be dinamyc as now is column series.

I have tried the PowerKPI but when I put series, the system put each line of product (perfect) but repeat the same expected for each product (and i dont want this).

Could someone help me on this?

[v-jiascu-msft]

Hi @dobregon ,

Can you share a little dummy sample, please? Maybe we can find a workaround.

Best Regards,

[dobregon]

---

@v-jiascu-msft wrote:

Hi @dobregon ,

Can you share a little dummy sample, please? Maybe we can find a workaround.

Best Regards,

---

Thanks for the response @v-jiascu-msft . As an example we can use this table 

timestamp	product type id	product id	Market Hours	Value	Expected
1/1/2019 0:00	5	1	0	0	0
1/1/2019 1:00	5	1	0	0	0
1/1/2019 2:00	5	1	0	0	0
1/1/2019 3:00	5	1	0	0	0
1/1/2019 4:00	5	1	0	0	0
1/1/2019 5:00	5	1	0	0	0
1/1/2019 6:00	5	1	0	0	0
1/1/2019 7:00	5	1	0	0	0
1/1/2019 8:00	5	1	0	0	0
1/1/2019 9:00	5	1	0	0	0
1/1/2019 10:00	5	1	1	58	100
1/1/2019 11:00	5	1	1	173	263.16
1/1/2019 12:00	5	1	1	266	275.4
1/1/2019 13:00	5	1	1	307	324.36
1/1/2019 14:00	5	1	1	420	500
1/1/2019 15:00	5	1	1	535	600
1/1/2019 16:00	5	1	1	684	995.52
1/1/2019 17:00	5	1	1	617	700
1/1/2019 18:00	5	1	1	175	500
1/1/2019 19:00	5	1	1	182	400
1/1/2019 20:00	5	1	1	163	200
1/1/2019 21:00	5	1	0	0	0
1/1/2019 22:00	5	1	0	0	0
1/1/2019 23:00	5	1	0	0	0
1/1/2019 0:00	5	2	0	0	0
1/1/2019 1:00	5	2	0	0	0
1/1/2019 2:00	5	2	0	0	0
1/1/2019 3:00	5	2	0	0	0
1/1/2019 4:00	5	2	0	0	0
1/1/2019 5:00	5	2	0	0	0
1/1/2019 6:00	5	2	0	0	0
1/1/2019 7:00	5	2	0	0	0
1/1/2019 8:00	5	2	0	0	0
1/1/2019 9:00	5	2	0	0	0
1/1/2019 10:00	5	2	1	61	100
1/1/2019 11:00	5	2	1	184	263.16
1/1/2019 12:00	5	2	1	214	275.4
1/1/2019 13:00	5	2	1	113	324.36
1/1/2019 14:00	5	2	1	485	500
1/1/2019 15:00	5	2	1	168	600
1/1/2019 16:00	5	2	1	263	995.52
1/1/2019 17:00	5	2	1	352	700
1/1/2019 18:00	5	2	1	101	500
1/1/2019 19:00	5	2	1	244	400
1/1/2019 20:00	5	2	1	129	200
1/1/2019 21:00	5	2	0	0	0
1/1/2019 22:00	5	2	0	0	0
1/1/2019 23:00	5	2	0	0	0
1/1/2019 0:00	5	3	0	0	0
1/1/2019 1:00	5	3	0	0	0
1/1/2019 2:00	5	3	0	0	0
1/1/2019 3:00	5	3	0	0	0
1/1/2019 4:00	5	3	0	0	0
1/1/2019 5:00	5	3	0	0	0
1/1/2019 6:00	5	3	0	0	0
1/1/2019 7:00	5	3	0	0	0
1/1/2019 8:00	5	3	0	0	0
1/1/2019 9:00	5	3	0	0	0
1/1/2019 10:00	5	3	1	66	100
1/1/2019 11:00	5	3	1	149	263.16
1/1/2019 12:00	5	3	1	255	275.4
1/1/2019 13:00	5	3	1	211	324.36
1/1/2019 14:00	5	3	1	495	500
1/1/2019 15:00	5	3	1	547	600
1/1/2019 16:00	5	3	1	290	995.52
1/1/2019 17:00	5	3	1	642	700
1/1/2019 18:00	5	3	1	194	500
1/1/2019 19:00	5	3	1	88	400
1/1/2019 20:00	5	3	1	70	200
1/1/2019 21:00	5	3	0	0	0
1/1/2019 22:00	5	3	0	0	0
1/1/2019 23:00	5	3	0	0	0
1/1/2019 0:00	5	4	0	0	0
1/1/2019 1:00	5	4	0	0	0
1/1/2019 2:00	5	4	0	0	0
1/1/2019 3:00	5	4	0	0	0
1/1/2019 4:00	5	4	0	0	0
1/1/2019 5:00	5	4	0	0	0
1/1/2019 6:00	5	4	0	0	0
1/1/2019 7:00	5	4	0	0	0
1/1/2019 8:00	5	4	0	0	0
1/1/2019 9:00	5	4	0	0	0
1/1/2019 10:00	5	4	1	54	100
1/1/2019 11:00	5	4	1	118	263.16
1/1/2019 12:00	5	4	1	183	275.4
1/1/2019 13:00	5	4	1	286	324.36
1/1/2019 14:00	5	4	1	384	500
1/1/2019 15:00	5	4	1	192	600
1/1/2019 16:00	5	4	1	558	995.52
1/1/2019 17:00	5	4	1	625	700
1/1/2019 18:00	5	4	1	277	500
1/1/2019 19:00	5	4	1	282	400
1/1/2019 20:00	5	4	1	174	200
1/1/2019 21:00	5	4	0	0	0
1/1/2019 22:00	5	4	0	0	0
1/1/2019 23:00	5	4	0	0	0

As an example Product type 5 is fruits and product id like (banana, orange, apple, etc). The value is the benefits per hour per product id and the expected is the benefit expected per hour (the same for each product type, so each fruit will have the same expected benefit.)

So, that I'm looking is a chart with 2 Y Axis lines, like in Excel
- Primary value and series of product id

- Secondary the expected without series. (could be average)

I prefer 2 Y axis lines, but i can't find something similar in power bi.

That I can find in powerbi is the visual "line and clustered column chart". In this visual i can put the line as expected and the columns the values and series de produc id, but it is not an option becasue i can see the worst product per hour becasue when i have 10 product id the columnbs will be very little.

I want to have the expected as column without series and the line with series, but i doesn't exist this option.