Clustered columns all have the same values for each time period.

[Anonymous]

Visualizations are not segregating attribute counts as desired.  Counts for all attributes displayed in clustered column charts the same instead of different – representing the counts for each attribute per time bucket.

 I searched and didn't find a matching article 😊

Link to Background doc 

Link to .xlsx data file 

[Portrek]

Hi.

You need to create a Calendar Table commun between the column

Try create a new table and insert the code

CALENDAR = ADDCOLUMNS(CALENDAR(MIN('Raw Data'[Created]),MAX('Raw Data'[Resolved])),"MOUTH", UPPER(FORMAT([Date], "mmmm")))

Then you put the mouth in X-Asis.

Best Regards.

Choose this reply like the resolution of your problem.

[Anonymous]

Thanks - I'll give it a try and let you kn ow how it goes 💪

[Anonymous]

Thanks @Portrek

I used your code to create the table.  The table included Date and Month columns.

I did not get the result I was looking for so I tried to join the new table with the Raw Data table on the CREATED, RESOLVED and CLOSED fields.  Still not what I was looking for.

I created another table (brute force) with DATE | DAY | MONTH | YEAR columns and still not getting the results I'm seeking.  Tried joining tables on CREATED-DATE and no change.

I understand you're advising me to create a date lookup table for represent all days in the RawData Table (i.e. DateLookup).  Please clarify how DateLookup should relate to RawData (i.e. are they to be joined?  if yes, on which fields?)  And then how to define parameters within the visual definition.

I need to have a date hierarchy available to enable drill down YEAR > MONTH > DAY.

Any assistance is much appreciated.  Thanks.

[Portrek · Accepted solution]

Hi.

Take a look if its help you..

https://we.tl/t-3PYAeIaF3q

Best Regards.

[Portrek]

If this post resolv your problem, acept the solution for close the post. Thanks.