Line Graph Visual Help

[inglexjc]

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:

ReportDate	Month	AvgInactiveDevices
4/6/2025	Apr	142
4/13/2025	Apr	143
4/20/2025	Apr	132
4/27/2025	Apr	136
5/4/2025	May	136
5/11/2025	May	145
5/18/2025	May	141
5/25/2025	May	165
6/1/2025	Jun	156
6/8/2025	Jun	142
6/15/2025	Jun	130
6/22/2025	Jun	92
6/29/2025	Jun	77
7/6/2025	Jul	75
7/13/2025	Jul	67
7/20/2025	Jul	64
7/27/2025	Jul	84
8/3/2025	Aug	109
8/10/2025	Aug	123
8/17/2025	Aug	117
8/24/2025	Aug	106
8/31/2025	Aug	110
9/7/2025	Sep	112
9/14/2025	Sep	129
9/21/2025	Sep	140
9/28/2025	Sep	144
10/5/2025	Oct	138

Is this possible?

[samratpbi]

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

[inglexjc]

Got it:

[inglexjc]

Got it:

[samratpbi · Accepted solution]

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

[inglexjc]

@samratpbi do I need to change something in the Visualizations?

I don't see "Type"