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 i...
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

OsmanEmi's avatar
OsmanEmi
Frequent Visitor
5 years ago

I have updated to show expected output on my original message apoligies for not being clear enough.

  • Pragati11's avatar
    Pragati11
    Super User
    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