Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Insert a graph line based on a condition

I have a question regarding a line graph. I have a data sheet which has a list of applicants for different events. Which looks something like this:

IDRegistration dateEvent
11121-3-2023T16
11112-4-2023T13
111011-3-2023T14
110918-4-2023T14
110825-3-2023T14
110720-3-2023T17
11065-4-2023T16
11057-3-2023T15
110416-4-2023T14
110321-3-2023T13

 

I want to create a graph where I see the application progress overtime (which can be done easily by adding the date column to the X-axis and the ID column to the Y-axis). But besides that I want to add a second line for each event. (So one graph which has the overall line and a line for T13, one graph with T14, etc.) How do I do this?

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , You can use the event in the legend 

 

If not you have create measures to do that

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors