Forum Discussion
Combo Custom Combination - Excel to Power BI
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
1 Reply
- PhilipTreacy
Super User
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
