Forum Discussion

DanielFlores's avatar
DanielFlores
Regular Visitor
10 months ago
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...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • DanielFlores's avatar
    DanielFlores
    10 months ago

    Hi v-tejrama 

     

    I would like to say thank for all the support. the issue was solve.

    Thanks again

DanielFlores's avatar
DanielFlores
Regular Visitor
10 months ago

Here is the table, thanks for your support. 

Tips codeMaterial AcustomerPlantTest NameDL-15°DL-25°DL-45°DL-75°DL-110°
111122AKGeoProcess 192.4291.0890.5791.0888.22
111122AKGeoProcess 293.191.2990.7290.9187.95
111122AKGeoProcess 39593.290.0191.689.4
111122AKGeoProcess 49191.690.890.586.5
  • v-tejrama's avatar
    v-tejrama
    Community Support
    10 months ago

    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