Pivot table with defined or Selected or Customised period showing

[peter8848]

Hi All,

I Created a report from a sales data based / listed on week number/year with $ and quantity etc but would like to show the two sales data comparison between two consecutive pre-defined period both under data selection and column labels showing too.

Say i would like to show sales between two periods for week 3 2018 to week 2 2019 (Period 1) VS week 3 2017 to week 2 2018 (Period 2)

Anyway we can show them as below?

Period 1 Period 2

$xxx $xxx

however, when i tried using slicers or timelines it looks like it cannot be produced by a customized period as on the column label only shows year/month which only start from 1 of the calendar year or 1st of the month.

Cheers,

Peter

 

[peter8848]

Hi All,

What I want to achieve is as below. Many thanks ( I am thinking about doing two pivot tables on one report page?)

https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/

Cheers,

Peter