How to create a chart with separate values but in the same chart

[DanielFlores]

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.  I would like to represent them in the same chart, Please see the attached as references. In the example below you have a sets of values (DL15, DL25 DL45, DL75 and D110) for three differents items.

How can I transform (order) my data to get this kind of chart?

Thanks for your support

 

[v-tejrama]

Hi  @DanielFlores ,

Thank you @vivien57   for the response provided! 

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!

[DanielFlores · Accepted solution]

Hi @v-tejrama 

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

Thanks again

[v-tejrama]

Hi  @DanielFlores ,

It would be helpful if you could share the workaround you used to resolve the issue, as it could benefit other community members who encounter a similar problem.

Thank you,

Tejaswi.

[tayloramy]

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 

[DanielFlores]

Sure, 
Here is an example of my data

Thanks

[tayloramy]

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. 

[DanielFlores]

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

[v-tejrama]

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

[MasonMA]

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. 

[DanielFlores]

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.

[MasonMA]

You should be able to do this by using 'Test Name' for Small Multiples. 

[vivien57]

Hello @DanielFlores ,

To display separate lines for each category (DL15, DL25, DL45, DL75, D110), your data should be in a long format. Here's an example:

| Item | Category | Value |

|--------|----------|-------|

| Item A | DL15 | 10 |

| Item A | DL25 | 15 |

| Item A | DL45 | 20 |

| Item A | DL75 | 25 |

1. Import your data

2. If your data is in wide format (each category as a column), use Power Query to transform it:

   - Select the columns DL15 to D110.

   - Click Transform > Unpivot Columns.

   - This will give you a table with Item, Category, and Value.

3. Create a Line Chart:

   - X-axis: Item

   - Y-axis: Value

   - Legend: Category

Have a nice day,

Vivien 

[DanielFlores]

Thanks @vivien57 for your support.

I did it, but I still can't get the correct chart I want. There is a way to have all the values dL15,d25,d45,d75,d110 in the line fo each item? 

[vivien57]

Hello @DanielFlores ,

you must pivot so that DL15, DL25... becomes a category and not a column name

Have a nice day,

Vivien