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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.