Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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.
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
Hi @Sam7
You could add the filter to 'Filters on this page' in the filter pane instead of 'Filters on this visual'
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |