Reporting on Split Columns

Power BI
1

Hi,

As per the attached I am trying to sum up the number of requests per person.

The data has the requester’s in a comma delimited format.
I split the column out and get three columns with users in them.

I now want to visualize the number of requests allocated per requester

Request

2

Hi Radley

You need to unpivot the columns the get the desired Result. Please see the enclosed sample Pbix file.

Test.pbix (39.6 KB)

image
image

Hope this helps
thanks

3

Hi,

Could you send me the source data so I can see how you got to the results.

Cheers
Radley

4

Hi

Sorry I don’ t have the source data, as i quickly build something to test it. But the source data looks like the data you have.

image

Then i just unpivot it and it should look like
image

Hope it helps

Thanks

Thanks

5

How do you pivot on three columns?

6

You unpivot them in the query editor. Really easy to do. You select the correct columns, then right click and you’ll see the option there.

Sam