Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
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
User | Count |
---|---|
106 | |
85 | |
81 | |
73 | |
71 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |