I have several line charts that are missing months in the data due to either no new account opened or no transaction depending on the measure. I have added a master calendar in hopes that it might fix my problem however it hasn't and I believe the problem is going to be resolved in my set analysis.
I have the below dimension and measure in a line chart with Aug2018 missing. I do have a master calendar with AcctOpenedDate as the key and AcctOpenedMonth as one of the fields. I would like to see Aug2018 with 0 for the value, if there is none.
Thanks for the reply, unfortunately the notification went to my spam folder, so I just realized someone had replied. I did try your suggestion, but it swapped my months to a numeric value and scale. So not sure what to do?!