Multiple date columns when values are shown on rows

[dodgun]

I'm trying to mimic this table:

Column 1: 2018 current month
Column 2: 2019 current month
Column 3: 2018 YTD (in 2018)
Column 4: 2019 YTD

So far I have this:

I've enabled 'show on rows' to get the values to show as rows, but am missing the columns piece. If I use the date and filter, it doesn't achieve what I'm looking for. If I use a measure it is limited to 1 KPI (sales, spend, etc).

Is there any way to do this? Thank you.

[v-shex-msft · Accepted solution]

HI @dodgun ,

The simplest way is enter to query editor and do unpivot columns feature on date fields which you mentioned.

Unpivot columns (Power Query)

Then you can use original row field, unpivoted attribute fields and value field to create a matrix visual.

Regards,

Xiaoxin Sheng