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

[themistoklis]

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:

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

[v-yuta-msft · Accepted solution]

Hi themistoklis,

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

 

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

  

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

 

Regards,

Jimmy Tao

[themistoklis]

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?