Forum Discussion

dancarr22's avatar
dancarr22
Icon for Helper V rankHelper V
2 years ago
Solved

Line chart - show dates at a given interval on X-axis

Hello,   We have a Power BI Report with a line chart on it.  The X-Axis is a date field.  By default the (X-axis) Type is 'Continuous' and shows Jan-2024, Feb-2024, etc as the X-axis values.  Pleas...
Need Help
  • PIYUSHPRAJAPATI's avatar
    PIYUSHPRAJAPATI
    2 years ago

    DAX: 

    ENDDATE = EOMONTH(Orders2014[Order Date],0) and Just change the Categorical Instead of the Continuous.

     

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

I'm reasonably sure 'categorical' is the right choice with the EndOfMonth field in the x-axis field well.

Can you show what happens when you try that + a small data sample so I can test please?