Combo Custom Combination - Excel to Power BI

[AstraMaster1972]

Hi there, I am new to Power BI and need some help & guidance.

I can currently produce this in Excel.

Combo Custom Combination Graph (3rd Axis to the right)

    

This is the base data in an Excel table, example showing 01/03/2021 to 08/03/2021 but I have the full month in my table.

	01/03/2021	02/03/2021	03/03/2021	04/03/2021	05/03/2021	08/03/2021
Shift Output	24	22	26	16	0.00001	12
2nd shift	0	0	0	0	0	0
Capacity P/D	23	23	23	23	23	23
Un-Utilised Capacity	-3	1	9	11	23	3
Scheduled Blades	26	22	14	12	0	20
Design Capacity	23	23	23	0	0	0
Design Predicted Utilisation	100	100	100	100	100	75
Lead time	05/04/2021	05/04/2021	05/04/2021	05/04/2021	05/04/2021	05/04/2021
Order Drop Dead Date	0	0	0	0	0	0
Un-Utilised Capacity	-3	1	9	11	23	3

I only want to display the data which is displayed in Red.

What Chart Visualization is best for this combo?

It would be nice to have some sort of date slicer on my chart to be able to view a range of dates,

Any help & guidance would be fab!

Cheers

[PhilipTreacy]

Hi @AstraMaster1972 

Not entirely clear as you say you only want to display the data in red, but you also ask what is the best chart for this combo.

If you just want to display the data in red, use a clustered column/line visual.

If you want to display all the data as shown in your Excel combo chart, use a line/stacked column visual.

Regards

Phil