Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Pivot multiple rows into columns

Hi all, 

 

I am working on a dataset and have been struggling to transform the dataset into the desired format. I need to to pivot the dataset to make it visually more readable. 

 

Below is that the dataset looks like 

Capture1.PNG

Device,    Estimate, Time,        Value
Device1,  False,     00:00:00,    2278.08
Device1,  False,     00:30:00,    2378.08
Device1,  False,     01:00:00,    2478.08
Device2,  False,     00:00:00,    1278.08
Device2,  True,      00:30:00,    1378.08
Device2,  False,     01:00:00,    1478.08

.....

Device100,  False,     23:30:00,   99999

 

The data is coming in every 30 mins. I would like to pivot the data so that 1 row contains all the reading for a device and display the estimated column e.g. as below

 

Capture.PNG

 

Please note this is sample data and i will have dozons of devices and 24 hour data with 30 mins intervals. Can anyone please suggest how the above can be achived. 

 

Many thanks

4 REPLIES 4
Anonymous
Not applicable

Does anyone have any suggestions please?

I don't think PBI is designed for that kind of manipulation. The purpose of PBI is to take data in several formats and then display them afterwards, not reorganize the root data.

ShNBl84
Helper II
Helper II

Have you tried highlighting both the value and time columns and then unpivoting?

Anonymous
Not applicable

Yes, I tried that but it didnt work for me.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.