Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors