I trying to populate my table or axis with period even though there are gaps
Hi I am trying to populate my table with a date or period even though is no data so my graph runs continuously along its axis. I came across an artcile below but I seemed to get a mixed results, mainly due on my part most likely. xreference: Show-dates-with-no-data-on-continuous-date-axis This is a sample graph, you will notice for 2019 Q2 and Q3 are missing, and again for 2020 we are now in Q4 but no axis details. The actrual raw data is processed through powerquery, what you see here is just one of the 3 data sources, this one is easier to see the gaps on the chart. All 3 tabels look at a calendar I created, and each table has an "ApplicationDate" which points to the date field on my calendar. My calendar date range covers early and future dates to capture all data; the 3 main data soures are refreshed periodically. This is my sample data: I have a measure that just simple counts the value which is then linked to the calenader against the "ApplicationDate" which is how I get the breakdown by Month and Quarter for each data type. I am maybe needing to cover all date ranges in the calendar and any that are missing from my data soure are populated with a '0' in the "DataValue" column for each table. Sample Data Type2 ApplicationDate DataType DataValue 02/05/2019 Data2 1 29/10/2018 Data2 1 27/09/2019 Data2 1 27/09/2019 Data2 1 03/10/2019 Data2 1 18/11/2019 Data2 1 18/11/2019 Data2 1 08/11/2019 Data2 1 22/10/2019 Data2 1 28/02/2020 Data2 1 28/02/2020 Data2 1 09/04/2020 Data2 1 Or am I over complicating this task? many thanks Chris
