Display graph with mindate-5 and maxdate+5 with date from the date filter

[dakkineni]

Hi,

I have a power BI report with a date between slicer and a graph that displays web page trafic during campain. when I choose the date as 1/5/2016 to 1/31/2016, the Line and stacked column chart is  working fine. But my requirment is when I choose 1/5/2016 and 1/31/2016 in the slicer the graph should display data from 1/1/2016 to 2/5/2016 (5 days before min date and 5 days after max date from the slicer)

How can we achieve this in the graph. Any help!!

Thanks

Deepika

[Eric_Zhang]

@dakkineni

What is in your graph? That requirement is a little weird for me, could you try to create two measures and use them in filter. Say

minDate = MIN('columnInSilicer')-5

maxDate = MAX('columnInSilicer')+5

[dakkineni]

Hi,

I have a power BI report with a date between slicer and a graph that displays web page trafic during campain. when I choose the date as 1/5/2016 to 1/31/2016, the Line and stacked column chart is  working fine. But my requirment is when I choose 1/5/2016 and 1/31/2016 in the slicer the graph should display data from 1/1/2016 to 2/5/2016 (5 days before min date and 5 days after max date from the slicer)

How can we achieve this in the graph. Any help!!

Thanks

Deepika