Help please! Clustered column chart to count dates separately (three date columns per line item)

Hi Icey 

I have changed date type but still the same result.  What I get is the picture on the left - what I want is the picture on the right. 

I can only produce picture on the right by creating a new data table in excel which counts dates by month.  Problem with this is that it is not linked to the other data in the table if I click on it in Power BI.

I think problem is that I am using "Planned to Complete" field on the axis to give me the date range so data is only counted on basis of this column rather than independently.

Kind regards,

---

Icey wrote:

Hi Anonymous ,

Make sure your Planned, Actuals, and Forecast are in right format of date. And then, another Date table is not needed.

 

If your date format is not correct, change it:

 

Best Regards,

Iceyy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

---

Simon