CODEWITHSUNDEEP
powerbi
likuku
likuku

Reputation: 31

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

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

Upvotes: 1

Views: 1051

Answers (2)

likuku
likuku

Reputation: 31

Problem solved.

Refer to link below for complete solution

Solution Here

Upvotes: 0

Nelson Gomes Matias
Nelson Gomes Matias

Reputation: 1997

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!

Upvotes: 0

Related Questions