Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi, I am working with the following line chart:
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
Hi @AfootDesert41, please share some sample data and screenshot of what you are trying to acheive
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.
You can write measures to define how conditional formatting behaves.
Check this blog:
and history posts like this:
https://community.powerbi.com/t5/Desktop/Conditional-Formatting-using-DAX-measure/m-p/888399
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:
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?
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.