Forum Discussion

Rav3n's avatar
Rav3n
New Member
5 years ago
Solved

Display individual lines

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.

 

 

General Comment
Need Help
Tips and Tricks
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    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.

2 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    5 years ago

    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's avatar
    amitchandak
    Super User
    5 years ago

    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