Conditional Formatting Markers on a Line Chart

[MStark]

Hey! Im looking to have a visual as follows

Line chart by month and value with legend being location. Want when the value goes below specific amount for each location the markers turn red. 

The way I did it was with 2 charts overlapping eachother but it gets real messy anytime i change location or month slicer and then it doesnt overlap exactly and it wont allow me to use as slicer correctly (basically not workable but putting here to show what Im looking for)

Back chart:

front chart

Whats a better way to get this done? There used to be the option to color Markers with conditional formatting but that option is no longer available.

Or any ideas for showing this information (value by location with flag by month its below range) in a visual format?

Thanks in advance!

[V-yubandi-msft]

Hi @MStark ,

May I know if the issue has been resolved, or are you still facing any challenges? Please let us know if you need any additional details or assistance.

Thanks.

[V-yubandi-msft]

Hi @MStark ,

Just following up has your issue been resolved, or are you still having any difficulties? If you need more information or help, please let us know.

Thanks.

[V-yubandi-msft]

Hi @MStark ,

I wanted to check in regarding your issue. Has it been resolved, or do you need any further information. Let me know if you’d like more details.

Thanks.

[V-yubandi-msft]

Hi @MStark ,

Thank you for trying the approach @djurecicK2  suggested. I understand it didn’t fully meet your needs.
As @Shahid12523 , mentioned, there are some other options that could be a better fit for your situation.

If you need more flexibility, you might consider using the Deneb custom visual, which allows you to set marker color rules directly.

I appreciate your inputs @Shahid12523 @djurecicK2.

Regards,
Yugandhar

[Shahid12523 · Accepted solution]

Best approach: Use a line chart + scatter plot combo.
- Line shows all values by location/month.
- Scatter adds red markers only where values fall below threshold.
Alternative: Use Deneb for full control or custom visuals from AppSource.
Fallback: Use icons or tooltips to flag low values

[djurecicK2]

Hi @MStark ,

 Unfortunately, you have to use a workaround like this one:

https://www.youtube.com/watch?v=yZFSS6GOrTo

https://community.fabric.microsoft.com/t5/Desktop/Is-there-a-way-to-conditionally-format-markers-in-...

[MStark]

Hi @djurecicK2,

Appreciate you looking into this and your fast response!

I saw those tricks previously but doesnt seem to work with a Lengend. Im able to get the conditional formatted markers by having it first as a bar chart but once I add the lengend in the markers disappear

[djurecicK2]

Hi @MStark ,

 Yes you are right. Sorry, I didn't notice that you were using legend- I agree that solution will not work.