Forum Discussion
Solved
How to create a chart with separate values but in the same chart
Hi I would like to create a chart to represent diferent values but in seperate lines. I have theses categories DL15, DL25 DL45, DL75 and D110, each category will have differents values for each item...
Sure,
Here is an example of my data
Thanks
Hi, you may consider first normalizing your data and turning them into rows with a category and value.
In Power Query, unpivot column as in picture.
After tidying your data, in reporting use 'Attribute' for small Multiples to display categories side by side.
Hi MasonMA , thanks for your reply, this chart is closer that what I looking for, but, there is a way to have same chart with all the "dl" values in the same line and then split for each process, in my example each dot in the line shows a dl15, d25,d45... for each item or process.
You should be able to do this by using 'Test Name' for Small Multiples.