Quarter show only a month in bar chart

[#1]

Dear Experts,

        I have a problem with the quarterly balance show at the bar chart.

I normally join all the dates. Here is the code.

LOAD Date ,

month(Date) as Month,

if(len(Date)>0,'Q'&Ceil(Month(Date)/3)) as Quarter,

year(Date) as Year,

[Sr No.],

Customer_Account as [Customer Account],

[Old Customer Account],

Customer_Name as [Customer Name],

Balance,

Balance1,

Status

From

xx..\5.8.15.xlsx];

  

There have four dates of two months in Q3 but It only show two dates of a month in the bar chart. Let me know how to fix it.

Best Regards,

Kyaw Myo Tun

[#2]

Dear Daniel,

         Thanks for your patient and precious help. give me a minute. Lets find the solution together.

Best Regards,

Kyaw