Forum Discussion
Simple Timeline Chart
Hello,
Very new to PowerBI, looking to make a simple chart like this, based on the data table below for one project. I assume it has to be an x-y scatter, but I don't actually have y values. Suggestions appreciated.
Ed
| Project | Header | Salary | Fringe Benefits | Contractuals/Commoditites | Internal Billing | Travel | Foreign Travel | Equipment | F&A | Reconciled Date | Start Date | BP End Date | Award End Date |
| Project 1 | Award Total | $12,921.00 | $0.00 | ($0.43) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 2023 March 23 | 2020 October 1 | 2022 December 31 | 2022 December 31 |
| Project 1 | KFS Budget | $12,921.00 | $0.00 | ($0.43) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 2023 March 23 | 2020 October 1 | 2022 December 31 | 2022 December 31 |
| Project 1 | Committed | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 2023 March 23 | 2020 October 1 | 2022 December 31 | 2022 December 31 |
| Project 1 | Encumbered | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 2023 March 23 | 2020 October 1 | 2022 December 31 | 2022 December 31 |
| Project 1 | Expended | $10,322.90 | $2,597.67 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 2023 March 23 | 2020 October 1 | 2022 December 31 | 2022 December 31 |
| Project 1 | Remaining Balance | $2,598.10 | ($2,597.67) | ($0.43) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 2023 March 23 | 2020 October 1 | 2022 December 31 | 2022 December 31 |
| Project 2 | Award Total | $160,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 2023 March 23 | 2020 June 1 | 2023 May 31 | 2023 May 31 |
| Project 2 | KFS Budget | $80,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 2023 March 23 | 2020 June 1 | 2023 May 31 | 2023 May 31 |
| Project 2 | Committed | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 2023 March 23 | 2020 June 1 | 2023 May 31 | 2023 May 31 |
| Project 2 | Encumbered | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 2023 March 23 | 2020 June 1 | 2023 May 31 | 2023 May 31 |
| Project 2 | Expended | $0.00 | $0.00 | $1,774.19 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 2023 March 23 | 2020 June 1 | 2023 May 31 | 2023 May 31 |
| Project 2 | Remaining Balance | $80,000.00 | $0.00 | ($1,774.19) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 2023 March 23 | 2020 June 1 | 2023 May 31 | 2023 May 31 |
2 Replies
Eddie1 , You have to check some of these custom visuals
amitchandak - thank you, it is getting me closer.
