cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JDS_near_CHS
New Member

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.

02.26.21.PNG

 I searched and didn't find a matching article 😊

Link to Background doc 

Link to .xlsx data file 

1 ACCEPTED SOLUTION

Hi.

 

Take a look if its help you..

 

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

 

Best Regards.

 

View solution in original post

5 REPLIES 5
Portrek
Resolver III
Resolver III

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.

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

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.

Hi.

 

Take a look if its help you..

 

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

 

Best Regards.

 

View solution in original post

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

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors