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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
NunoTrigo1986
Helper I
Helper I

Line chart where data points has no colors

I created a line chart in Power BI using a union of two tables: one containing a normal measure (legend) with several data points over time, and another with the same structure but where the measure (legend) has only a single data point.

In Power BI Desktop, everything works fine when I select the legends I want to display. However, after publishing, the measures with just one data point lose their color. Interestingly, if I hover over the timeline they belong to, the color temporarily appears while hovering.

Is this a bug? Is there a way to fix this issue?

 

pictures 

NunoTrigo1986_0-1732311883355.png

all the data points on the table are on the chart. although they are not visible BUT, if i touch  with a mouse on the right time line, they appear :

NunoTrigo1986_1-1732311958348.png

 

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @NunoTrigo1986 - In Power BI Desktop, line charts render single data points as small dots or markers, and the legend retains the color for those points.
After publishing, Power BI Service sometimes fails to render single data points consistently. The color in the legend or chart may temporarily reappear during interactions, such as hovering, but it does not persist.
Line Chart Limitations:

Power BI assumes line charts represent continuous data over time. When a legend contains a measure with only one data point, it may treat this as incomplete and fail to render it correctly unless there's user interaction.

 

1. Force Consistent Display Using Marker Shapes
Enable markers for the lines in your chart. This ensures single data points are visually represented, even if there’s no line connecting them.
Steps:
Select the line chart in Power BI Desktop.
Go to the Format Pane → Shapes → Turn Show markers to On.
Publish and test the report again.
2. Add a Dummy Data Point
To address the issue of single data points, you can add a dummy data point to the dataset so that each legend item has at least two data points. This makes Power BI treat it as a continuous series.
Example:
For a measure with one data point (e.g., "3/1/2019"), add a duplicate row with a different timestamp but the same value.
3. Switch to a Different Chart Type
If adding dummy points or enabling markers does not work, consider switching to a scatter plot or similar visual, which handles single data points better than a line chart.
4. Check Compatibility and Updates
Ensure your Power BI Desktop version and Power BI Service are updated to the latest version. Microsoft periodically fixes rendering bugs in updates.

 

 

 

Line Graphs and Area charts | Dash-Intel

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
rajendraongole1
Super User
Super User

Hi @NunoTrigo1986 - In Power BI Desktop, line charts render single data points as small dots or markers, and the legend retains the color for those points.
After publishing, Power BI Service sometimes fails to render single data points consistently. The color in the legend or chart may temporarily reappear during interactions, such as hovering, but it does not persist.
Line Chart Limitations:

Power BI assumes line charts represent continuous data over time. When a legend contains a measure with only one data point, it may treat this as incomplete and fail to render it correctly unless there's user interaction.

 

1. Force Consistent Display Using Marker Shapes
Enable markers for the lines in your chart. This ensures single data points are visually represented, even if there’s no line connecting them.
Steps:
Select the line chart in Power BI Desktop.
Go to the Format Pane → Shapes → Turn Show markers to On.
Publish and test the report again.
2. Add a Dummy Data Point
To address the issue of single data points, you can add a dummy data point to the dataset so that each legend item has at least two data points. This makes Power BI treat it as a continuous series.
Example:
For a measure with one data point (e.g., "3/1/2019"), add a duplicate row with a different timestamp but the same value.
3. Switch to a Different Chart Type
If adding dummy points or enabling markers does not work, consider switching to a scatter plot or similar visual, which handles single data points better than a line chart.
4. Check Compatibility and Updates
Ensure your Power BI Desktop version and Power BI Service are updated to the latest version. Microsoft periodically fixes rendering bugs in updates.

 

 

 

Line Graphs and Area charts | Dash-Intel

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors