Select X days after a selected date in the slicer

[Anonymous]

Hi,

I have seen some posts with almost similar questions but I haven't found the solution yet.

https://community.powerbi.com/t5/Desktop/How-to-show-next-2-days-of-selected-date/m-p/335396#M150062

This one seemed close, but it has 3 slicers and I only have one.

So I have 

Date	Store Number	Sales
1-1-2010	1	1500
1-2-2010	1	1700
1-3-2010	1	1800

 there are some more stores and some more dates. But I want to select one date and then select 28 days ahead of the selected date in the slicer.

This is my slicer.

The graph should display 28 days after the selected slicer date.

Could someone please help.

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Check the following steps.

1# Create a CALENDAR table and use 'CALENDAR'[Date] as slicer.

2# Create a measure as below and add it to the visual filter: measure = 1

Measure = IF(SELECTEDVALUE('Table'[Date])>=SELECTEDVALUE('CALENDAR'[Date])&&SELECTEDVALUE('Table'[Date])<SELECTEDVALUE('CALENDAR'[Date])+3,1,0)

Result would be shown as below and you can change "+3" to "+28" in your scenario.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Well, either create a disconnected date table for your slicer or you will have to use ALL/ALLEXCEPT/REMOVEFILTERS in some sort of measure. I'm not clear on the graph you posted, is that what you want to see or ?

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[Anonymous]

No the graph, is not what I want to see unfortunately that shows all dates. But once I select a date I want it to show all dates 28 days after the selected date on the slicer. So for example if I select 1-1-2010, I want the graph to show 1-1-2010, 1-2-2010, 1-3-2010, till 1-28-2010

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Check the following steps.

1# Create a CALENDAR table and use 'CALENDAR'[Date] as slicer.

2# Create a measure as below and add it to the visual filter: measure = 1

Measure = IF(SELECTEDVALUE('Table'[Date])>=SELECTEDVALUE('CALENDAR'[Date])&&SELECTEDVALUE('Table'[Date])<SELECTEDVALUE('CALENDAR'[Date])+3,1,0)

Result would be shown as below and you can change "+3" to "+28" in your scenario.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-jayw-msft]

Hi @Anonymous ,

Here's my PBIX, hopefully works for you.

Best Regards,

Jay

[v-jayw-msft]

Hi @Anonymous ,

It should be "," or ";" not ".".