Display 2 lines for different years in a line chart

[Caiz]

I have a table "GA Logo Churn", which has a calculated column named "% Logo Churned". The data looks like this:

 I am trying to show a line for the Logo Churns of the last 12 months (march 2020-march 2021) and another for the year before that (march 2019-march 2020). When I add these into the line graphs they combine values instead of show separate for different years.

How do I get it to show the 2 line graphs for each year?

Thanks

[v-luwang-msft · Accepted solution]

Hi @Caiz ,

You could try the following steps:

Step1,create a sort table as below:

Step 2, use the following measure  and then new column base on the measure:

newyear = 
IF (
    (
        MAX ( 'Table'[Year] ) = 2019
            && MAX ( sort[sort] ) >= 3
    )
        || (
            MAX ( 'Table'[Year] ) = 2020
                && MAX ( sort[sort] ) < 3
        ),
    "2019 mar to 2020 mar",
    IF (
        (
            MAX ( 'Table'[Year] ) =2020
                && MAX ( sort[sort] ) >= 3
        )
            || (
                MAX ( 'Table'[Year] ) = 2021
                    && MAX ( sort[sort] ) < 3
            ),
        "2020 mar to 2021 mar",  IF(MAX ( 'Table'[Year] ) = 2019
            && MAX ( sort[sort] ) <3,"before 2019 mar",
        "after 2021 mar"
    )
))

Base on the two steps ,to create visualization:

If you want something more natural, you could try the following solutions:

And final you will get the below:

You could download my pbix file to learn more details！

Wish it is helpful for you!

Best Regards

Lucien

[FrankAT]

Hi @Caiz ,

use a measure instead of a calcultated column like this:

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Caiz]

Hi there @FrankAT , how did you set up the line chart I can't get mine looking like this? What table columns did you put in what section? Also what would Sum of Value do in the chart if I'd like the Y axis to be % Logo Churned? This is what mine looks like:

[amitchandak]

@Caiz , Not very clear. Refer to these two blogs. Change the duration as per need

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...