Line Chart Issue

[TonesTables]

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, 

[v-prasare]

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

[v-prasare]

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 support

[Praful_Potphode]

Hi @TonesTables ,

Lookslike your Data model is mssing relationships.

can you share a snapshot of it?

Thanks and Regards,

praful

[Nabha-Ahmed]

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 = On

This forces Power BI to show the event name on each point.

Best regards

Nabha ahmed

[marcelsmaglhaes · Accepted solution]

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:

1. Check for missing UUIDs or names
   You mentioned that not all rows have a UUID or 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.

2. 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 EventDate and EventScore).

3. 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.

4. 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: EventType or UUID

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.