Forum Discussion
Graph HELP
Graph DrawingHi,
I need help with how to plot a graph.
The Bottom Axis needs to range from the oldest date going to the newest date. For example from the data below April 2019 to November 2020.
The axis on the side will have the business names.
The graph content will be the GWP Limit spread across the start date to the end date. Within this the bar will be spilt in 2 to show what has already been written.
Can anyone guide me? Is this possible?
Thanks,
Abby
| Bus | Start | End | GWP Limit | Written GWP |
| Bus 1 | April 2019 | March 2020 | 5,000,000 | 50,000 |
| Bus 2 | December 2019 | November 2020 | 3,000,000 | 2,000,000 |
| Bus 3 | August 2019 | September 2020 | 2,000,000 | 1,000,000 |
Hi abbylong,
Currently, normal power bi visuals do not support dynamic analysis across multiple date fields. You can try to use custom visual Gantt if it is suitable for your requirements.
In addition, you can also take a look at the following link to expand a detail records mapping table to analysis across multiple date fields records:
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng
2 Replies
Hi abbylong,
Currently, normal power bi visuals do not support dynamic analysis across multiple date fields. You can try to use custom visual Gantt if it is suitable for your requirements.
In addition, you can also take a look at the following link to expand a detail records mapping table to analysis across multiple date fields records:
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng
Thank you so much for your help!
