Forum Discussion

inglexjc's avatar
inglexjc
Post Patron
10 months ago
Solved

Line Graph Visual Help

Is there a way for the line graph to show Months on the bottom X-axis but have the points show the Daily info?

 

We like the month being simply listed at the bottom but don't want the monthly numbers to show we want the daily numbers to show in the line:

But when we add day then the X axis changes to show Day and Month.

Raw data:

ReportDateMonthAvgInactiveDevices
4/6/2025Apr142
4/13/2025Apr143
4/20/2025Apr132
4/27/2025Apr136
5/4/2025May136
5/11/2025May145
5/18/2025May141
5/25/2025May165
6/1/2025Jun156
6/8/2025Jun142
6/15/2025Jun130
6/22/2025Jun92
6/29/2025Jun77
7/6/2025Jul75
7/13/2025Jul67
7/20/2025Jul64
7/27/2025Jul84
8/3/2025Aug109
8/10/2025Aug123
8/17/2025Aug117
8/24/2025Aug106
8/31/2025Aug110
9/7/2025Sep112
9/14/2025Sep129
9/21/2025Sep140
9/28/2025Sep144
10/5/2025Oct138

Is this possible?

 

Need Help
  • samratpbi's avatar
    samratpbi
    10 months ago

    Hi, in the line chart x-axis settings, you can make the Type as Continuous

     

     

    Hope this helps.

    If this helps to resolve your problem then please mark it as solution.

    Thanks - Samrat

5 Replies

  • samratpbi's avatar
    samratpbi
    Super User
    10 months ago

    Hi, inglexjc  it seems you might have saved the Report Date column in a different datatype (instead of Date). Or if you have a date table defined that has relationship with your fact table, then use that date column from there.

    Thanks - Samrat

  • samratpbi's avatar
    samratpbi
    Super User
    10 months ago

    Hi, in the line chart x-axis settings, you can make the Type as Continuous

     

     

    Hope this helps.

    If this helps to resolve your problem then please mark it as solution.

    Thanks - Samrat