Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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'
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |