Reporting on Split Columns

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

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

Hi,

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

Cheers
Radley

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

How do you pivot on three columns?

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