Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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
Icon for Community Champion rankCommunity Champion
10 years ago

Anonymous so what is your question here ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    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
      Icon for Community Champion rankCommunity Champion
      10 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        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?