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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
JoyceW
Helper II
Helper II

Highlight values / shapes in line chart with dax.

Hi everyone,

I have a line chart with revenue per month. I want the lowest and the highest month highlighted with red for low and green for high. I used this video: https://www.youtube.com/watch?v=hmk6PxDtbNs&t=0s

 

And created this measure:

 

MaxMin Omzet =
VAR Omzet = [Omzet]
VAR MAXOmzet =
MAXX(
ALLSELECTED(Datumtabel[Jaar], Datumtabel[Maand], Datumtabel[Maandnr]),
[Omzet]
)
VAR MinOmzet =
MINX(
ALLSELECTED(Datumtabel[Jaar], Datumtabel[Maand], Datumtabel[Maandnr]),
[Omzet]
)
VAR Result =
SWITCH(
TRUE(),
[Omzet]=MAXOmzet, “Green” || [Omzet]=MinOmzet, “Red”,
“blue”
)
RETURN Result

 

The video says to turn it to a column chart and with column color select the fx next to color. then select field value and then the measure. But I cannot select the measure. I have tried setting the measure to text, but that is not an option. What am I doing wrong? 

 

 

1 REPLY 1
lbendlin
Super User
Super User

Make sure you created a measure and not a calculated column

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 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