Forum Discussion
Line Chart Issue
I'm having trouble with the below line chart. Seeing if anyone could assist to put me on the right track please.
Using these tables with relationships connected, although I can not get all data to plot on line chart for each person.
Visual I am trying to get:
Trying to getwhat I am getting
Table information and Line Chart elements.
| Tables | ||
| MergedCalendars | Bio | Ams |
Columns | About | About | About |
| UUID | UUID | UUID |
| Event |
|
|
| EventDate |
|
|
| EventScore |
|
|
| EventType |
|
|
| Education Provider | Education Provider |
|
|
| Sport | Sport |
|
| Discipline(s) | Discipline(s) |
|
|
|
|
Table | MergedCalendars | Description |
Columns | About | name of person (not all rows have person’s name) |
| UUID | unique id (not all rows have UUID) |
| Education Provider | Provider: name of college |
|
|
|
Power Bi Visual | Line Chart | Description |
X axis | EventDate | date of event |
Y axis | EventScore | 1, 2, or 3 |
Legend | EventType | Lifestyle = 1, Education = 2, Sport = 3 |
Data Label. Title | Event | name of event. i.e: xmas break, study period, test match |
Thanks,
Hey TonesTables,
It looks like the issue might be related to missing data or filters in your model. Here are a few things you can try to troubleshoot the problem:-
Check for missing UUIDs or names
You mentioned that not all rows have aUUIDor person's name. If your visual relies on a relationship to a person table (or if you’re using a slicer), those rows might be excluded. Try removing any filters or slicers on people to see if more data appears. -
Test your data with a table visual
Before using the line chart, I recommend creating a simple table visual with the following fields:-
UUID -
Event -
EventType -
EventDate -
EventScore
This helps verify if the expected events are actually present and have valid data (especially
EventDateandEventScore). -
-
Avoid overlapping data points
Since your Y-axis only uses values 1, 2, and 3 (for EventScore), multiple events might overlap on the chart. This can make it seem like some data is missing. -
Try a scatter chart instead
If the line chart still isn’t displaying everything, try switching to a scatter chart with:-
X-axis:
EventDate -
Y-axis:
EventScore -
Legend or Details:
EventTypeorUUID
-
This often gives you a clearer picture when dealing with discrete values like 1, 2, and 3.
Hope this helps! Let me know if you want help checking your data model or relationships.
-
5 Replies
Hey TonesTables,
It looks like the issue might be related to missing data or filters in your model. Here are a few things you can try to troubleshoot the problem:-
Check for missing UUIDs or names
You mentioned that not all rows have aUUIDor person's name. If your visual relies on a relationship to a person table (or if you’re using a slicer), those rows might be excluded. Try removing any filters or slicers on people to see if more data appears. -
Test your data with a table visual
Before using the line chart, I recommend creating a simple table visual with the following fields:-
UUID -
Event -
EventType -
EventDate -
EventScore
This helps verify if the expected events are actually present and have valid data (especially
EventDateandEventScore). -
-
Avoid overlapping data points
Since your Y-axis only uses values 1, 2, and 3 (for EventScore), multiple events might overlap on the chart. This can make it seem like some data is missing. -
Try a scatter chart instead
If the line chart still isn’t displaying everything, try switching to a scatter chart with:-
X-axis:
EventDate -
Y-axis:
EventScore -
Legend or Details:
EventTypeorUUID
-
This often gives you a clearer picture when dealing with discrete values like 1, 2, and 3.
Hope this helps! Let me know if you want help checking your data model or relationships.
-
Hi TonesTables
If your goal is to create a chart where:
Y-Axis: EventScore (1, 2, or 3)
Legend: EventType (Lifestyle = 1, Education = 2, Sport = 3)
Data Label / Title: Event Name (e.g., “Xmas Break”, “Study Period”, “Test Match”)
then the issue is that Power BI does not automatically display a text event name as a data label unless it is used on the axis or provided through a measure.Here are the correct configurations to make it work:
---✔ Option 1 — Column/Bar Chart (Recommended)
Use the event name as the X-Axis to allow Power BI to show it as a label.
Fields:
X Axis: EventName
Y Axis: EventScore
Legend: EventTypeName (Lifestyle, Education, Sport)
Then enable labels:1. Go to Format
2. Expand Data Labels
3. Turn Data labels = On
4. Turn Category labels = On (this ensures the event name appears)This configuration displays:
EventScore on Y
EventType as Legend
Event names as visible labels
---
✔ Option 2 — If you need the Event Name as a label on a Line/Scatter chart
Create a DAX measure to use as the label:
Event Label = SELECTEDVALUE(Event[EventName])
Then:
1. Go to Format → Data Labels
2. Set Label Style = Category
3. Ensure Data Label = OnThis forces Power BI to show the event name on each point.
Best regards
Nabha ahmed
Hi TonesTables,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Praful_Potphode & Nabha-Ahmed,Thanks for your prompt response
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community supportHi TonesTables ,
Lookslike your Data model is mssing relationships.
can you share a snapshot of it?
Thanks and Regards,
praful
Hi TonesTables,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support
