Power BI - How to show next 2 days of selected date?

1
votes

I'm new to Power BI and I am having difficulties. I have some slicers as filters and two chart as below: Sample Report

The bottom chart shows data with data according to date selected in the slicers which is straight forward. E.g. The slicer selected 15-Oct-2017, the bottom chart should shows 15-Oct-2017 as well.

The upper chart should shows the next 2 days of the selected chart, i.e. data of 16&17-Oct-2017 should be shown. How do I achieve this in a dynamic way so that when slicer selection change, this chart changes accordingly?

Thanks in advance

2
powerbi

2 Answers

0
votes

you can achieve this by creating 2 measures like that:

NextDayValue = CALCULATE(COUNT([columnYouWantToCount]), DATEADD([DateColumn],1,day))
Next2DayValue = CALCULATE(COUNT([columnYouWantToCount]), DATEADD([DateColumn],2,day))

and then use these measure in your charts.

Hope that helps!

0
votes

Problem solved.

Refer to link below for complete solution

Solution Here