Unpivot columns including those columns as it is

[Anonymous]

Hello,

Is it possible to keep the columns and unpivot them as well?

I have a hierarchy Year > Qtr > Month with Sales (in M), these are columns but attributes / Value column will be generated after unpivot with Sales(in M) column. 

The requirement is to show them in vertical and horizontal slicers  in the same report with different tabs e.g,

When I unpivot (Year / Qtr /month), the columns will become rows (attribute / Value / Sales ) and there will not be any Year /Qtr /Month Column.

but I want my data to be  something like this

Year	Quarter	Month	Attrubute	Value	Sales (in M)
2019	Q1	Jan	Year	2019	340
2019	Q1	Jan	Qtr	Q1	340
2019	Q1	Jan	Month	Jan	340
2019	Q1	Feb	Year	2019	290
2019	Q1	Feb	Qtr	Q1	290
2019	Q1	Feb	Month	Feb	290
2019	Q1	Mar	Year	2019	400
2019	Q1	Mar	Qtr	Q1	400
2019	Q1	Mar	Month	Mar	400
2019	Q2	April	Year	2019	80
2019	Q2	April	Qtr	Q2	80
2019	Q2	April	Month	April	80
2019	Q2	May	Year	2019	310
2019	Q2	May	Qtr	Q2	310
2019	Q2	May	Month	May	310
2019	Q2	June	Year	2019	440
2019	Q2	June	Qtr	Q2	440
2019	Q2	June	Month	June	440
2019	Q3	July	Year	2019	220
2019	Q3	July	Qtr	Q3	220
2019	Q3	July	Month	July	220
2019	Q3	Aug	Year	2019	100
2019	Q3	Aug	Qtr	Q3	100
2019	Q3	Aug	Month	Aug	100
2019	Q3	Sept	Year	2019	90
2019	Q3	Sept	Qtr	Q3	90
2019	Q3	Sept	Month	Sept	90
2019	Q4	Oct	Year	2019	200
2019	Q4	Oct	Qtr	Q4	200
2019	Q4	Oct	Month	Oct	200
2019	Q4	Nov	Year	2019	180
2019	Q4	Nov	Qtr	Q4	180
2019	Q4	Nov	Month	Nov	180
2019	Q4	Dec	Year	2019	700
2019	Q4	Dec	Qtr	Q4	700
2019	Q4	Dec	Month	Dec	700

[v-chuncz-msft]

@Anonymous 

You may duplicate the three columns first and then select Unpivot Only Selected Columns.

[Anonymous]

Duplicate in the database? or on the report, because I tried duplicating on the report and it didn't help.

In the database we are not allowed to make changes.