crosstab column display the value name first, and then the columns like a excel pivot

[Giacomo101]

Hello,

I need help for this:

The result above is that I want to get the title of the values first and then the year so I can compare the pieces between the two years.
In PowerBI how do I get the same thing, since there is no option to invert the values with the year as on pivots? PBI puts all the values and then year

My values are formulas in DAX, those in the print screen is just one example

Any idea is appreciated. Thank you

[Uzi2019 · Accepted solution]

Hi @Giacomo101 

Unfortunetly No, You cant change the format as per the excel.

But you can Unpivot this format like this

select product and year > Transform > Unpivot other column 

so you will get the information like this format

take your data in matrix

you can disable the total or subtotal value. you will see the desired result.

I hope i answered your question!