Forum Discussion

F_Reh's avatar
F_Reh
Icon for Post Patron rankPost Patron
4 months ago
Solved

Points on X-Axis

Hi,

 

I have a line graph like this:

 

 

The Dates appear along the X-axis on the bottom, but its not "absolutely clear" which data points on the line of the graph they correspond to. There is nothing in the settings allowing me to put veritical gridline.

 

Kindly suggest anyway in which I can improve this aspect.

  • F_Reh Hi, you may consider using Error bar as in below picture. Build a Dummy Measure, 

    Dummy = 0 and use it for Upper Bound, use your Aggregated Measure for Lower Bound. 'Absolute' for 'Relationship to measure'. 

     

3 Replies

  • I've accepted MasonMA's solution (which works as can be seen in the snippet of the line graph below).

     

    Shai_Karmani - I can't see Type in the settings for X-axis for the line graph I am using:

     

     

    The version of Power BI I am using is 2.150.1926.0 64-bit (January 2026) which is a Onpremises Remote Server type.

     

    Regards

     

  • F_Reh Hi, you may consider using Error bar as in below picture. Build a Dummy Measure, 

    Dummy = 0 and use it for Upper Bound, use your Aggregated Measure for Lower Bound. 'Absolute' for 'Relationship to measure'. 

     

  • On a line chart the X-axis Type is set to Continuous by default, which is why the vertical gridlines toggle is hidden. Open the Format pane, expand X-axis, and switch Type from Continuous to Categorical. The X-axis Gridlines option will then appear and you can turn it on.

    If you also want each data point clearly marked on the line, expand the Markers section under the line and turn Markers on, then pick a shape and size you like. Together that gives you both the vertical gridline and a visible point at every date.

    If this helped, a thumbs up and accepting the solution would be appreciated.

    Best regards,
    Shai Karmani