Forum Discussion

pe2950's avatar
pe2950
Icon for Helper I rankHelper I
9 years ago
Solved

Clustered 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 ...
  • Sean's avatar
    Sean
    9 years ago

    pe2950

    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: