Power BI From and To Date Filtering with One Slicer

[Sam7]

Based on this: https://www.youtube.com/watch?v=W5n8-5Q7mII

How do I make this work, when I don't want the dates in the visual?  This works only if you have both dates in the visual.  I want to add this to the whole page, with a varity of charts. 

Thanks

[Sam7]

I have a whole page of visuals.  I want to have one slicer (single pick-date) and all the visual to change.  Based on the YouTube video - this is 99% of what I want, you can create a measure and add to filters, which only works on those visuals that have the date columns as outputs.  You cannot add the measure to visuals (or on whole page).  I do not want two date columns on my pie or funnel graphs. 

[Anonymous · Accepted solution]

Hi @Sam7,

You can try to create a calculated table to expand the raw table date ranges based on two date fields and a category field.
Then you can link two tables and use the new table date field as the source of the slicer to achieve one 'from ~ to' date slicer affects whole report pages.

Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community

Regards,

Xiaoxin Sheng

[James-Harpin]

Hi @Sam7 

You could add the filter to 'Filters on this page' in the filter pane instead of 'Filters on this visual'