Forum Discussion
Advocate IIPower BI From and To Date Filtering with One Slicer
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
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
3 Replies
- James-Harpin
Resolver IV
Hi Sam7
You could add the filter to 'Filters on this page' in the filter pane instead of 'Filters on this visual'
Sam7I 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.
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
