Forum Discussion

vanessa's avatar
vanessa
Post Patron
10 years ago

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

Something like this:

Need Help

6 Replies

    • vanessa's avatar
      vanessa
      Post Patron
      10 years ago

      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's avatar
        ankitpatira
        Community Champion
        10 years ago

        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.