Forum Discussion

OsmanEmi's avatar
OsmanEmi
Frequent Visitor
5 years ago
Solved

Merging Row Values in a column

Hi All,

 

I have a column with row values I would like to merge however unsure how I should progress with this.

 

For example in the below table I would like to merge all "Blue Barrels".

Any insights would be greatly appreciated.

The expected output would be for all instances of blue barrels to be merged in relation to store number or store name.
for example
store number 935
blue barrel 120l - 20
blue barrel 240l - 40

I would like it to be summed to display
store number 935
blue barrel - 60


 

Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi OsmanEmi ,

     

    You can use a matrix visual in Power BI to achieve this:

    • Select matrix visual
    • Move "Store Name" to ROWS section
    • Move "Type" to COLUMNS section
    • Move "COUNT(Type)" to VALUES section

    As you haven't attached a sample data file, I can't try it at my end, but try the above solution.

     

    Thanks,

    Pragati

4 Replies