Forum Discussion
Help please! Clustered column chart to count dates separately (three date columns per line item)
Hi Anonymous ，
Is what the screenshot shows below the result you want? If not, please give me more details then I can help you better. This is my PBIX file.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Icey
This is type of chart I am looking for, however 'count' is not correct. If I look at the data (dates) in the table I should have:
Planned - 1 in January and May, 3 in June, 1 in October and November.
Actuals - 1 in January, March, June and 2 in July.
Forecast - 1 in October and November.
Is it possible for chart to count dates?
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,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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