Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 DateSales
1-1-2020300
20-1-2020700
5-2-2020500
27-2-2020900
25-2-2020300
10-1-2020400
8-1-2020200