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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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
Top Kudoed Authors