Graph HELP

[abbylong]

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

[Anonymous · Accepted solution]

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

[abbylong]

Thank you so much for your help!