Forum Discussion
pe2950
Helper I
9 years agoClustered Column Chart - Grouping by same month over years?
I'm trying to create a clustered column chart that would show a count of leads, by month, with each cluster representing the same month. I've got the data in the format i want it, the query has ...
- 9 years ago
Alternatively you can drag your Date field to the Axis and keep only the MONTH from the resulting Hierarchy
then drag your Date field again but this time to the Legend and keep only the YEAR
and finally place your Measure (which won't need any adjustments now because of the Legend) in the Value
If you have many years - you can limit what shows on the chart with a Slicer or some type of filter limiting the years
One thing to note about this approach is that it will let you compare months of different years not only consecutive years
for example Monthly data in 2016 vs monthly data in 2012 only
Like this...
Hope this helps! :smileyhappy:
v-chuncz-msft
Community Support
9 years ago