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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Vallirajap
Resolver III
Resolver III

Date format and reference line in PBI Visual

Hii All, 

I stuck in one scenario where I have passed a date column in the X-axis (continuous) and a metric value in the Y-axis. Now I use the refence line option to highlight today's date, like below.

 

Vallirajap_1-1728564910541.png

In the above image, the date is not displayed in the exact format (dd-mm-yyyy). So I change the X-axis (categorical). The date format is fixed, but the reference line option is disabled in the format pane.

Anyone know the solution for the above scenario? Please let me know
Thanks in advance.

 

1 REPLY 1
MNedix
Super User
Super User

Heya,

I don't think the X-Axis Constant Line works with Categorical X-axis, you may need to revisit the Data table and format it accordingly.

 



If the post helped then please give it a Kudos and mark it as the solution so others can see it.
Cheers,

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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
Top Kudoed Authors