Compare two periods on one axis X

[Anonymous]

We want to calculate volumes for two different periods of time.

The mentioned above periods are calculated based on three factors:

1. Start day of the first period
2. Start day of the second period
3. Number of days (the same for the firs and second period). In this particular case it’s 8 days

The periods are DAX calculated as below:

• measure formula for the first period

                             OkresI ilość = var dstartI=minx(StartI;[ParametrI])

                                                    var dendI=dstartI+liczba_dni[Wartość liczba dni]

                                                    var wyn=Calculate(SUM(BI_ZST_ALL[Ilosc]);DATESBETWEEN(BI_ZST_ALL[DataNadania];dstartI;dendI))

                  Return wyn

• measure formula for the second period

                             OkresII ilość = var dstartII=minx(StartII;[ParametrII])

                                                     var dendII=dstartII+liczba_dni[Wartość liczba dni]

                                                    var wyn=Calculate (SUM(BI_ZST_ALL[Ilosc]);DATESBETWEEN(BI_ZST_ALL[DataNadania];dstartII;dendII))

                               Return wyn

At that moment we ware able to prepare chart as below:

In result we want to get a chart showing volumes for the two periods on a single X axis.
It must start from 1 to number of the days (indicated by parameter – in this case 8 days)

 

 Kind regards

[Greg_Deckler · Accepted solution]

You could overlap 2 charts and use transparency.