Pull Row Values to Specific Columns

[Celine2022]

Hello,

I have been trying to find a solution for a table I have been working on.  

I have multiple columns, but each column only needs one row of data per date.

I need to keep the column names but only pull a specific row data per column for it to read like below;

Date	nOffered	tHandle	tAnswered
01.07.2022	81	13823003	80
02.07.2022	71	13341018	67

Could anyone point me in the right direction of how to resolve this please or if it can be done in PowerBi.

Thank you

[Celine2022 · Accepted solution]

Thank you for the feedback and tips to try. How I resolved it was I unpivoted the metrics columns, merged the metrics with the attributes, pivoted again and removed the columns not required.

[v-easonf-msft]

Hi, @Celine2022 

I think you can remove the column 'Attribute' and the group table by column 'Date'.

Best Regards,
Community Support Team _ Eason

[PC2790]

Hey @Celine2022 ,

You can try to group by on the date column.

Based on what logic you want the values(highlighted) for the three columns to be shown?

[amitchandak]

@Celine2022 , Not very clear. You should use slicer/filter in the report

[Celine2022]

Hello, Thank you for the response. I tried that in the visualisation but I still need to create measures out of the values that I need to get into the columns so I am unable to do that as multiple attributes appear under the one metric so I was hoping to reduce to the one value I need to use to create measure required for the reports.