Forum Discussion
Helper IClustered Column Chart - Grouping by same month over years?
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:
Helper IData looks like this:
StartOfMonth LeadCount Year Month
1/1/2017 100 2017 1
2/1/2017 90 2017 2
etc...
Id like a column chart that looks like this:
Column 1 = January 2016, Column 2 = January 107, Column 3 = Febuary 2016, Column 4 = Febuary 2017
I think i need a DAX with same period last year...
Community ChampionAlternatively 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:
Sean,
What if you have two seperate queries. For example, I have Membership enrollment from last fiscal year in one query and enrollment data from this year in another. I have them separate because I regularly update this year's data as the year progresses. So how can I have a clustered bar chart that has the number of enrollments last year next vs. the current number of enrollments with the queries being separate?
Sincerley,
Trent