Forum Discussion

paulthangaraj's avatar
paulthangaraj
Regular Visitor
6 years ago

Line Chart (Revenue over Years)

Dear all,   Greetings, i have been creating this Power BI Report with the following Columns Project Start Year Project name Region Revenue Current Year Next Year in Two years 2015 AA ...
Need Help
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

hi paulthangaraj ,

 

Create a column in your data as follows:

 

Year Group = IF([Project Start Year] = YEAR(TODAY()), "Current Year",
                           IF([Project Start Year] < YEAR(TODAY()), "Previous Year", "Next Year"))

 

Create a line chart.

Move Year Group  to the axis area, Region column to legend area and move your sumaarised value or a calculation to Values area.

 

Thanks,

Pragati

                              

  • paulthangaraj's avatar
    paulthangaraj
    Regular Visitor
    6 years ago

    Thank you for the reply,
    there is a little misunderstanding i guess.

    I am using the start year in the report to select. But it does not matter if this is current year or an year later.
    Current year is always 2020 for now 

    in the table i have just the values for the current year and i want the chart to show exactly as current year as mentioned not as 2020 or 2021.