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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors