Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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 




Take a look if its help you..


Best Regards.


View solution in original post

Resolver III
Resolver III



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.

Not applicable

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

Not applicable

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.



Take a look if its help you..


Best Regards.


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

Helpful resources

Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors