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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
DataMarsh
Frequent Visitor

Denormalisation of multiple values per cell with counts against each in Power BI

I have a bit of a strange one, where I have more than one value against one count, i.e. the count is the same for both values, so the values have been merged into one cell, is there any way to split out so that I can use it in a visualisation in Power BI?

For example in the image below, on row 3 both Apple and Pear have the value 3, but I need to have these in a separate row like the image on the right to get it into a visualisation that makes sense, i.e. 3 against Apple and also 3 against Pear. Any ideas, the source is a Google/Excel spreadsheet, I am hoping that this can be done in Power BI rather than the source (which I am unable to edit)?
Unmerge cells but copy value.jpg

1 ACCEPTED SOLUTION
Daniel29195
Super User
Super User

@DataMarsh 

 

this is doable with power query .

select the column you want to split, then go  under transform --> split by columns ,  and in the configuration, choose to split by row .  ( dont forget to put the delimiter base on which you want to split the data on ) 

 

Daniel29195_0-1707745233804.png

 

 

 

If this helps you with your question, please mark it as the solution so can you can help other people in the community to find it easily .

 

View solution in original post

1 REPLY 1
Daniel29195
Super User
Super User

@DataMarsh 

 

this is doable with power query .

select the column you want to split, then go  under transform --> split by columns ,  and in the configuration, choose to split by row .  ( dont forget to put the delimiter base on which you want to split the data on ) 

 

Daniel29195_0-1707745233804.png

 

 

 

If this helps you with your question, please mark it as the solution so can you can help other people in the community to find it easily .

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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