Compare differrent time periods in same Chart by weeks

[Anonymous]

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

[amitchandak · Accepted solution]

@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

[Anonymous]

With some tweeking your first link helped me achive my desired result - Thanks a lot! 🙂