cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
themistoklis New Contributor
New Contributor

Multiple Line Graph with one Dimension on each Axis and 4 Measures

Hello All,

 

I have created a line graph which has the year month on X Axis and 4 measures displayed on Y Axis. See following Image:

image.png

I would like to take the analysis one step further and add another dimension (Person) to this graph.

So essentially what i would like to achieve is select two or three persons from a filter and then the graph will show instead of 4 lines, 8 lines for the 2 persons (4 services for each one of them) and 12 lines for the 3 persons. This will help me compare the performance between the persons im looking at.

 

I tried to do that on PowerBi but with no luck. Is this functionality available on the software?

 

Attached on this link is a spreadsheet where on the first sheet i show the lines for one person and on the second sheet i have a sample dataset for 3 persons. Based on the data from the second sheet i would like to create the relevant line graph where i will show 12 lines.

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Multiple Line Graph with one Dimension on each Axis and 4 Measures

Hi themistoklis,

 

To achieve your requirement, click query editor-> transform->click on [service1], [service2], [service3] and [service4]->  unpivot columns.

1.PNG 

 

Then click add columns-> custom column to merge column [person] and [attribute] like below;

2.PNG  

 

Then applied and close, create a line chart and a slicer on person column.

3.PNG4.PNG 

 

Regards,

Jimmy Tao

 

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Multiple Line Graph with one Dimension on each Axis and 4 Measures

Hi themistoklis,

 

To achieve your requirement, click query editor-> transform->click on [service1], [service2], [service3] and [service4]->  unpivot columns.

1.PNG 

 

Then click add columns-> custom column to merge column [person] and [attribute] like below;

2.PNG  

 

Then applied and close, create a line chart and a slicer on person column.

3.PNG4.PNG 

 

Regards,

Jimmy Tao

 

View solution in original post

themistoklis New Contributor
New Contributor

Re: Multiple Line Graph with one Dimension on each Axis and 4 Measures

Hello @v-yuta-msft

 

This indeed works great on the data and when the 4 services belong to an existing table

 

In my case these 4 services are calculated measures (4 fields) in PowerBi and they dont actually belong to an existing table.

Is there a way if these are calculated measures to display them on the graph, or they all need to be on an existing table?

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 46 members 806 guests
Please welcome our newest community members: