Reply
New Contributor
Posts: 420
Registered: ‎04-14-2018
Accepted Solution

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


Accepted Solutions
Community Support Team
Posts: 2,503
Registered: ‎02-06-2018

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

Attachment

All Replies
Community Support Team
Posts: 2,503
Registered: ‎02-06-2018

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

 

Attachment
Highlighted
New Contributor
Posts: 420
Registered: ‎04-14-2018

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?