Forum Discussion
Need Help on splitting/combining values
ok i think it is easy :
- goto query editor
- select "ASsigned Person" column
- under "Split Column" in menu, choose "By Delimiter"
- Choose semicolor delimiter
- Click Advaced option and select "rows"
- click ok
and this will do, so in you graph, now you will get the data what you are looking for
- drop person on x axis and project id on value (and choose count as summarization)
can you share how your real data looks like?
Also do you always maximum 2 person like Person 1 / Person 2 or it can be more than 2 as well?
Sure, here is the table I'm working on in Direct Query.
Here are the charts that I'm trying to work with, with the top chart showing what I get, and the bottom filtered to show what I'm trying to make (with incorrect counts). But having trouble getting the values to correctly allocate to the individual persons.
ok i think it is easy :
- goto query editor
- select "ASsigned Person" column
- under "Split Column" in menu, choose "By Delimiter"
- Choose semicolor delimiter
- Click Advaced option and select "rows"
- click ok
and this will do, so in you graph, now you will get the data what you are looking for
- drop person on x axis and project id on value (and choose count as summarization)
Thanks, I think I'm getting slightly closer. I don't seem to have a "rows" option, this might due to not having the last couple updates.
It did split well into additional columns, I'm hopin to maybe add these together on my chart axis, but it looks like right now it is still filtering by the hierarchy.
i think you missed one step there , you need to choose Rows in advanced than columns