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

vanessa so what is your question here ?

  • 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.

      • vanessa's avatar
        vanessa
        Post Patron
        10 years ago

        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?