Area Chart

[vanessa]

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 have 2 areas: 1 for current year and 2nd for previous year. 

Something like this:

[ankitpatira]

@vanessa so what is your question here ?

[vanessa]

@ankitpatira

So can I achieve this?

The image i uploaded is of the Retail Analysis Sample dashboard.

I have just 1 column for date. And I want to display 2 areas: 1 for current year and 1 for the previous year.

Is it possible ?

[ankitpatira]

@vanessa 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.

[vanessa]

@ankitpatira

I 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?

[ankitpatira]

@vanessa in that case create conditional column via query editor as where year value in year column is equal to 2016 then current year else previous year and use that conditional column in legend area. unfortunately that will also be somewhat static as you would have to update that condition column each year but currently you can't use measure (like you proposed) under Legend area of Area chart.

[vanessa]

@ankitpatira

Is there any way i can use a dynamic filter for the graph under visual filter ?

I want to display the area graph for year greater than equal to previous year. Is it possible? or can we only use a static filter in powerbi by hardcoding the value?