Visualizing data monthly which contains only start date and end date

[JerryT]

Hi,

If I have every single sales order which contains [PN] [OrderDate] [Price] and [Qty], I can visualize the data to show the graph I desire like this.

Now I have another table which contains only [PN] [StartDate] [EndDate] [Price] [EstimatedPeriodQty].
Is this possible to visualize this table just like graph above?

The best solution I found here's posted by Mauriusz as below link to emulate the whole sales record.

https://community.fabric.microsoft.com/t5/Desktop/Calculate-pro-rated-amount-over-a-period-of-time/m...

But I'm curious, is there a built in function for power bi to do the job?

[Anonymous]

Hi @JerryT ,

You could try creating a new column that contains the month information by extracting it from the start dates or end dates columns.

Then drag and drop the newly created month column into the Axis field well to set it as the x-axis.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.