Forum Discussion

Vallirajap's avatar
Vallirajap
Icon for Resolver III rankResolver III
1 year ago

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.

 

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

  • MNedix's avatar
    MNedix
    Icon for Solution Sage rankSolution Sage

    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.