Forum Discussion
Clustered Column Charts Display
I have created a clustered column chart as shown below. There's two issues I'd like help with:
- The amount of whitespace between the clustered columns in each week. As the number of weeks reported grows, this problem is exacerbated as the whitespace remains relatively the same and the width of the columns shrinks to the point they are barely legible.
- The alignment of the clustered columns to it's correlating week on the x-axis. For example, the line chart has dots that align to the center of each reporting week. In the center of the chart, the columns for that week are vertically aligned to the center, but as you move to the extremities the columns get further and further away from the vertical center (or the dot). On the far right, the columns are so far off their vertical center that it's hard to tell which week the columns are aligned to.
In case it helps, each column is representative of the duration of an event in that week and the line chart is the average time those events took in each week (and yes, the negative values to make sense in this instance).
2 Replies
Hi rblnc
I would suggest you create a calendar table with week column like:2019-2-20,2019-2-27,2019-03-06....Then link calendar table and data table.Use the week column to get only these dates' value to get the clustered column charts.
Regards,
Hi,
Thanks for the response! I have a Calendar Table in place as you suggested. I originally thought the reason for all the whitespace was related to the correlating dates for the columns, but that's not the case. Within each segment / reporting week, the columns are sorted by an ID associated to the event and other than their reporting week are not aligned to the date of the event. As noted, there's a pattern in how the columns are aligning to each reporting week, which would suggest there's soemthing in the PBI logic??
