Pivot a table/Matrix to create new coloumn in Power BI

[Khomotjo]

Hello everyone :

I have data like this :

I want to pivot the coloumns so that I can create a visual like this :

Orders Knows = Open_Orders, Orders _Same Day=Same_Day_Orders,Orders_Finalised=Picked Orders and Orders_Late=Late_Orders

I can not simply add an identifier coloumn to my data because some of the measures for the current date are calculated from a previous date. I run a snapshot of the orders daily so I will only know late orders the next day/date.

[MFelix · Accepted solution]

Hi @Khomotjo ,

If this are measures on your model you don't need to pivot anything you just need to add those measurss top the visualization line and stacked column chart.

The data seems to be in the correct format so that you can make it work.

If the values are part of a column on your model then you use the same visual but add that column to the legend.