Bell Curve with User Filtered Date Range from a Dataset

[Chaipup]

Hi,

I'm trying to build a Bell Curve based on a date range in my database e.g. I have data from 2014 but I would like to create the chart based on a user filtered date range (slicer) which is usually a month or so's worth of data.

I've looked at the video below and it works perfectly for the whole table however it doesn't filter.

https://www.youtube.com/watch?v=5bPVMFrUnrU

My question is: How do I put a date filter on this!!

Thanks in advance

[v-yuta-msft]

Hi Chaipup，

"I'm trying to build a Bell Curve based on a date range in my database e.g. I have data from 2014 but I would like to create the chart based on a user filtered date range (slicer) which is usually a month or so's worth of data."

<--- Which column do you want to set your slicer on? In addtion, can you give some details about your table and expected result?

Regards,

Jimmy Tao

[Chaipup]

Hi Jimmy, thanks for your reply;

I have a date range field for each record: "BookingDate" which has data from 2014 to current. I want to be able to use a slider to have a user definable range. I then have a field called "DeliveryMinutes" which creates a value based on how many minutes early or late we collect from the customer. I want to be able to plot all these records and create a chart to show how well we're doing. I've done it in excel and works fine but that's because I only use a dataset from a particular time period.

In the video the guy uses the distribution for each record as the start and end of his date range (to give him the x-axis) which means when I build his Bell Curve graph it gives me all the records from the data warehouse.

I hope that helps?

Thanks

Iain