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
AfootDesert41
Regular Visitor

Is it possible to highlight an specific values on the x-axis of a line chart?

Hi, I am working with the following line chart:

 

AfootDesert41_0-1671217057323.png

The X axis is represented by a date with the format Year-Week of the year. I would like to apply some conditional formatting to the date values, so if an specific date value meets the condition, the font color (or background color) of that specific date is hightlighted from the others. Eg. Set a rule in the conditional formatting of the x axis, so if date = 202232 then font color or background color changes, and is different from all of the other values of the x axis

5 REPLIES 5
powerbiexpert22
Impactful Individual
Impactful Individual

Hi @AfootDesert41, please share some sample data and screenshot of what you are trying to acheive 

Aerick
New Member

Looking to do the same thing.  I want to highlight the date-based (x-axis) chart from a particular point onward.  Reason being that that was the date when a particular change went into effect and want to draw the users attention to it.

FreemanZ
Super User
Super User

I also found this thread in the forum which explicitly says that it is not possible at the moment, but this was 4 months ago:

 

https://community.powerbi.com/t5/Desktop/Conditional-formatting-of-X-axis-values/m-p/2675894

I tried using the measure aproach, and also the conditional formatting using rules, no positive result as of now. This is the measure that I wrote following the blog:

 

AfootDesert41_1-1671470267860.pngAfootDesert41_2-1671470396629.png

 

I've seen the conditional formatting reproduced multiple times in the case of tables. But for line charts, the story is different, at least, for conditional formatting on the values on the x axis. Is there any resource that explains this solution For line charts and Not Tables?

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!

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.