Forum Discussion
Compare differrent time periods in same Chart by weeks
Hi Guys,
Struggle a bit with this,
Read various posts but none that handle the exact issue:
I need in a clustered column chart to show sales per week (x-axis)
One measure that shows Actuals
One Measure that shows compare period
Two slicers being able to set date filters on both actual period and compare period
Should be able to show both values if the time period selected in both slicers is within the same time period or completly different.
Example:
Slicer Actual date: 1-1-2020 to 1-2-2020
Slicer Compare date: 1-1-2020 to 15-1-2020
Or:
Slicer Actual date: 1-1-2020 to 1-2-2020
Slicer Compare date: 2-2-2020 to 28-2-2020
I have offcause a date table but as well tried with a Compare date table and UseRelationship function.
Any suggestions?
Data example
| Sales Date | Sales |
| 1-1-2020 | 300 |
| 20-1-2020 | 700 |
| 5-2-2020 | 500 |
| 27-2-2020 | 900 |
| 25-2-2020 | 300 |
| 10-1-2020 | 400 |
| 8-1-2020 | 200 |
Anonymous , You need an independent date table for that
How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg
or
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
2 Replies
- amitchandakSuper User
Anonymous , You need an independent date table for that
How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg
or
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
- AnonymousNot applicable
With some tweeking your first link helped me achive my desired result - Thanks a lot! 🙂