How to show revenue, cost with different years

[lkt88888]

Hi all,

Right now, my power bi is showing

                      2020         2021

Product 1     Rev cost   Rev cost

                     XX   XX      XX  XX

Product 2     Rev cost   Rev cost

But I want it to show

                    Rev             Cost

                2020 2021   2020 2021

Product 1 XX    XX        XX      XX

Product 2 XX    XX        XX      XX

Please help. Thank you!

[v-shex-msft]

HI @lkt88888,

Did these 'Revenue' and 'Cost' are from different value fields, right?
If that is the case, I think you need to do unpivot column on the fields to convert the to attribute and values, then you can add the attribute field above the year field to show the visual graph as your requirements.

Unpivot columns (Power Query) (microsoft.com)

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@lkt88888 , Not possible unless you unpivot the revenue and cost

column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905