Creating months

I have a line chart that shows just one point for the month of JAN because my data has only month of data but I want to show the chart from JAN-DEC even though I have only one month data. How do I create the remaining months in quicksight ? Any techniques ?


Hi @Kingeorge ,

This is not possible . What is the datasource for your dataset ?


1 Like

Hello @Kingeorge - You need to have a Date Dimension Table for this and then utilize that along with your fact table to modify the dataset, that you are using (like Date Dim Left Outer Join Fact) for your QuickSight dashboarding. This way you can only get context of those additional months, for which data points are not even present in your fact table. Hope this helps!

1 Like