Forum Discussion
vanessa
Post Patron
Post PatronArea Chart
Hi, I want to create an area chart which has month ( this comes from a date column from which only the month is being pulled into the chart) on X axis and total sales on Y axis. The graph will h...
ankitpatira
Community Champion
Community Championvanessa You certainly can do that. Go to query editor in power bi desktop, select your date column right click and duplicate. Then select duplicated column, under Transform tab select Date dropdown, Year and Year which will extract out year out of date. Then simply use extracted year column under Legend section of Area chart along with Category and Axis values.
vanessaPost Patron
Post PatronI want the current year to be selected dynamically using YEAR(today()) and comparing it to the year from the date field. the aprroach you mentioned will be like a static selection. won't it?