Forum Discussion

kirill_vaynberg's avatar
kirill_vaynberg
New Member
9 years ago
Solved

Show all Dates on continuous X axis

I would like to have a line chart that plots a numerical value against date. Everything seems to work except for the Date axis: it's always stuck at showing Month/Year at best. I would like to axis t...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi kirill_vaynberg,

     

    When you drag the date column to Axis of a line chart, it will automatically enable date hierarchy. You can check the column name instead of the Date Hierarchy. The date value in the X-axis will display based on the visual width and number of records in this date column. We are not able to set interval for date in the X-axis, we can just specify the start date and end date.

     

     

    To display all date values in x-axis, the best option is to set X-axis type as Categorical, it will generate a horizontal scroll bar for us to view all data if there are two many records.

     

    Best Regards,
    Qiuyun Yu

frankvb's avatar
frankvb
Icon for Helper III rankHelper III
3 years ago

In the end I does anybody have a solution in the end for:

-line chart

-trend line

-display all values on x-axis

-missing values in the line chart not connected by line

?

EktaSoni_R's avatar
EktaSoni_R
Icon for Helper I rankHelper I
2 years ago

I am also looking for the same , want date format as mm/dd/yyyy but it is displaying as mmm-yyyy,

- Line chart --> x axis --> continous 

- Trend Line is required so can't change to the Categorical