Line chart - conditional marker color and labels only for specific months (native visual limitation)

[Vinesh23]

Hi everyone,

I’m working on a maintenance KPI trend in Power BI Desktop and facing a limitation with the native line chart.

Requirement:

• Show a continuous FPM (%) line by Fiscal Month.

• Display markers only for months where a rebuild occurred.

• Those rebuild markers should be red, while other months remain yellow or hidden.

• Also need numeric values visible near rebuild markers.

• Must remain in native Power BI visuals (no Deneb/custom visuals), and the chart already uses a Legend (asset code).

What I tried:

• Created a DAX measure that returns value only for rebuild months (else BLANK).

• Using this on Y-axis breaks the line (expected behavior with BLANKs).

• Conditional formatting for marker color is not available in line charts.

• Scatter plot allows markers but does not reliably show measure value labels.

• Overlaying visuals works, but I’d like to confirm whether a single native visual solution exists or if this is a product limitation.

Question:
Is there any supported way in native Power BI line/scatter visuals to:

1. Keep a continuous line,

2. Show markers only for selected data points,

3. Apply different marker colors conditionally , and

4. Display data labels only for those markers?

Or is this scenario officially not supported and requires:

• Multiple overlaid visuals, or

• Deneb/custom visual?

• Any other visuals that deliver the same idea?

Any guidance or confirmation from Microsoft/MVPs would be greatly appreciated.

Thanks in advance!

This is how I require :

This is the DAX I used (passed under values of data labels) and the one obtained:

[Jaywant-Thorat · Accepted solution]

Hi @Vinesh23 

This is a native Power BI line chart limitation. What you want (all together in one native visual) is NOT supported today.

Why your attempts fail (expected behavior):

• BLANK() → breaks the line (by design)
• Marker color cannot be conditionally formatted
• Data labels are all-or-nothing
• Scatter plot ≠ reliable timeline + legend behavior

What actually works (native-only options):
Option 1 : Overlay 2 visuals - Common & Recommended

• Visual 1: Line chart
  • Continuous FPM line
  • No markers
• Visual 2: Scatter chart
  • Only rebuild months
  • Red markers
  • Data labels ON
• Sync axes + transparent background
  • Native
  • Clean
  • Performant
  • Production-safe

Option 2: Line chart + constant lines (partial)

• Use Analytics pane
• Add vertical lines for rebuild months
• Add tooltip / label via page tooltip
• No red markers
• Less intuitive

Option 3: Accept limitation

• Show all markers
• Single color
• Use tooltip to highlight rebuilds

What you cannot bypass:

• No DAX workaround
• No formatting hack
• No hidden setting
• Legend blocks most advanced tricks

Remember:

This scenario is officially not supported in a single native Power BI visual.

To meet all requirements, you must use:

• Overlaid native visuals OR
• Deneb / custom visual (if allowed)

=================================================================
Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Jaywant Thorat | MCT | Data Analytics Coach | Super User
LinkedIn: https://www.linkedin.com/in/jaywantthorat/
Join #MissionPowerBIBharat: https://tinyurl.com/JoinMissionPowerBIBharat
#MissionPowerBIBharat
LIVE with Jaywant Thorat

[v-prasare]

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]

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

[danextian · Accepted solution]

Hi @Vinesh23 

The native visuals do not support conditonal formatting when legends are added. You can make the visual appear to look like it does but a bit finnicky to setup.

Create a disconnected table with the legend category repeated twice - one for the line and another .

for the marker.

Create a measure that references this table and conditionally returns a value depending on the type.   Total Revenue and Max Point are calculated separately and TREATAS is used to propagate a virtual relationship betwen the disconnected and Category tables. In the below measure, I'm return the marker only if it is equal to the max value among all the values in the visible row.

Category2 Value = 
VAR _type = SELECTEDVALUE ( Category2[Type] )
RETURN
SWITCH (
    TRUE (),
    _type = "Line",
        CALCULATE (
            [Total Revenue],
            TREATAS ( VALUES ( Category2[Category] ), Category[Category] )
        ),
    _type = "Marker",
        CALCULATE (
            [Max Point],
            TREATAS ( VALUES ( Category2[Category] ), Category[Category] )
        )
)

Markers are enabled for all categories, but they are set to transparent for those with a Line type. While it’s possible to enable markers only for the Marker type, doing so ensures there are no visible marker borders that inherit or match the line colors when hovering over an active marker. The visible markers are set to have the same color. As to the legend, it is disabled for the line chart and another visual is used to show just the legends for Line Type.

Please see the attached pbix.

[Jaywant-Thorat · Accepted solution]

Hi @Vinesh23 

This is a native Power BI line chart limitation. What you want (all together in one native visual) is NOT supported today.

Why your attempts fail (expected behavior):

• BLANK() → breaks the line (by design)
• Marker color cannot be conditionally formatted
• Data labels are all-or-nothing
• Scatter plot ≠ reliable timeline + legend behavior

What actually works (native-only options):
Option 1 : Overlay 2 visuals - Common & Recommended

• Visual 1: Line chart
  • Continuous FPM line
  • No markers
• Visual 2: Scatter chart
  • Only rebuild months
  • Red markers
  • Data labels ON
• Sync axes + transparent background
  • Native
  • Clean
  • Performant
  • Production-safe

Option 2: Line chart + constant lines (partial)

• Use Analytics pane
• Add vertical lines for rebuild months
• Add tooltip / label via page tooltip
• No red markers
• Less intuitive

Option 3: Accept limitation

• Show all markers
• Single color
• Use tooltip to highlight rebuilds

What you cannot bypass:

• No DAX workaround
• No formatting hack
• No hidden setting
• Legend blocks most advanced tricks

Remember:

This scenario is officially not supported in a single native Power BI visual.

To meet all requirements, you must use:

• Overlaid native visuals OR
• Deneb / custom visual (if allowed)

=================================================================
Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Jaywant Thorat | MCT | Data Analytics Coach | Super User
LinkedIn: https://www.linkedin.com/in/jaywantthorat/
Join #MissionPowerBIBharat: https://tinyurl.com/JoinMissionPowerBIBharat
#MissionPowerBIBharat
LIVE with Jaywant Thorat