Display individual lines

[Rav3n]

Hi All,

I've been using excel for analytics in the past, and witching now to Power Bi.  How can I display individual lines simultaneously without combining them into a single one.

I have 2 support groups to compare. Each has Requests and Incidents. I need 4 lines on the graph:

Data Center Incidents

Data Center Requests

Workstation Services Incidents

Workstation Services Requests

Didn't find any functionality to do so. If anyone has an Idea, I would really appreciate anyhelp.

[v-alq-msft · Accepted solution]

Hi, @Rav3n 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create a visual as below.

Or you can create a measure for each Re/In and put them in 'Values'.

Data Center Incidents = 
CALCULATE(
    SUM('Table'[Value]),
    FILTER(
        'Table',
        [Re/In]="Data Center Incidents"
    )
)

Data Center Incidents = 
CALCULATE(
    SUM('Table'[Value]),
    FILTER(
        'Table',
        [Re/In]="Data Center Incidents"
    )
)

Workstation Services Incidents = 
CALCULATE(
    SUM('Table'[Value]),
    FILTER(
        'Table',
        [Re/In]="Workstation Services Incidents"
    )
)

Workstation Services Requests = 
CALCULATE(
    SUM('Table'[Value]),
    FILTER(
        'Table',
        [Re/In]="Workstation Services Requests"
    )
)

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Rav3n , You can have multiple measures or you can use a legend, you can not have both.  In this case, you might have create 4 measures