Forum Discussion
How to create a chart with separate values but in the same chart
Hi DanielFlores,
Can you please provide sample data?
How to Get Your Question Answered Quickly - Microsoft Fabric Community
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
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.
Hi DanielFlores,
Can you please provide it in a useable format as described in How to provide sample data in the Power BI Forum - Microsoft Fabric Community ?With useable data I can make a PBIX file for you.
Here is the table, thanks for your support.
Tips code Material A customer Plant Test Name DL-15° DL-25° DL-45° DL-75° DL-110° 111122 A K Geo Process 1 92.42 91.08 90.57 91.08 88.22 111122 A K Geo Process 2 93.1 91.29 90.72 90.91 87.95 111122 A K Geo Process 3 95 93.2 90.01 91.6 89.4 111122 A K Geo Process 4 91 91.6 90.8 90.5 86.5 Hi DanielFlores ,
Thanks for sharing the screenshot and following up on this. I reviewed your setup, and it looks completely accurate. You’ve used the unpivot step correctly in Power Query, which allows each DL category to appear as an individual line in the same visual.
In your chart, the process names are displayed along the X-axis under Test Name, while the Y-axis represents the corresponding DL values. The legend placement at the top right and the use of data labels make the visualization clear and easy to interpret. Everything in your report aligns perfectly with the expected outcome, so your approach and final result are spot on.
Please find the attached PBIX and screenshot file for your reference.
Best Regards,
Tejaswi.
Community Support
