The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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:
ID | Registration date | Event |
1112 | 1-3-2023 | T16 |
1111 | 2-4-2023 | T13 |
1110 | 11-3-2023 | T14 |
1109 | 18-4-2023 | T14 |
1108 | 25-3-2023 | T14 |
1107 | 20-3-2023 | T17 |
1106 | 5-4-2023 | T16 |
1105 | 7-3-2023 | T15 |
1104 | 16-4-2023 | T14 |
1103 | 21-3-2023 | T13 |
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?