I am having trouble making a graph by month and year

[AThomasCF]

Previously, I had an issue where I needed to count the number of incident that occured each month and graph them in bar format. 

I managed to get them to work by using the Countrows Measure and plotting it against the date. However, I have been asked to include findings from back to 2022. When I attempt to do the same thing, I get them clustered purely as the quantity per year

or all months, with no year information

How do I show all months at the same time? Can I? Do I need to add a slicer so that I can switch between both?

Here are my visualizations

[amitchandak · Accepted solution]

@AThomasCF , If you use the expand icons, The reverse square Y. You will be able to see both month and year together

I usually use a date table with exclusive fields, joined to the table.

example

Date = Addcolumns(calendar(date(2012,01,01), date(2024,12,31) ), "Month no" , month([date])
, "Year", year([date])
, "Month Year", format([date],"mmm-yyyy")
, "Month year sort", year([date])*100 + month([date])
, "Qtr Year", format([date],"yyyy-\QQ")
, "Qtr", quarter([date])
, "Month",FORMAT([Date],"mmmm")
, "Month sort", month([DAte])
, "FY Year", if( Month(([DAte])) <7 , year(([DAte]))-1 ,year(([DAte])))
, "Is Today" ,if([Date]=TODAY(),"Today",[Date]&"")
,"Day of Year" , datediff(date(year([DAte]),1,1), [Date], day)+1
, "Month Type", Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY") )
,"Year Type" , Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)
)

[AThomasCF]

So, do you create that as a separate table, and then link the tables and then use the countrows as the y-axis?

EDIT: I did exactly that and it worked like a charm. Thank you, I really appreciate it!