Create a 2 bar and 2 line chart

[Anonymous]

Hi,

I'm trying to present a chart with 2 lines instead of one but power BI currently shows the line chart as a total for both years, instead of showing separately. The measure I included for the line chart is % ECL =divide(sum('Appended Loan'[ECL]),sum('Appended Loan'[NETBAL_IIS]))

My dataset and filters are as follows:

Anyone knows how to split the line chart?

Thank you.

[Icey · Accepted solution]

Hi @Anonymous ,

Just create two measures like so:

% ECL 2018 =
DIVIDE (
    CALCULATE (
        SUM ( 'Appended Loan'[ECL] ),
        YEAR ( 'Appended Loan'[Month] ) = 2018
    ),
    CALCULATE (
        SUM ( 'Appended Loan'[NETBAL_IIS] ),
        YEAR ( 'Appended Loan'[Month] ) = 2018
    )
)

% ECL 2019 =
DIVIDE (
    CALCULATE (
        SUM ( 'Appended Loan'[ECL] ),
        YEAR ( 'Appended Loan'[Month] ) = 2019
    ),
    CALCULATE (
        SUM ( 'Appended Loan'[NETBAL_IIS] ),
        YEAR ( 'Appended Loan'[Month] ) = 2019
    )
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[abhi9255]

Create 2 measures for 2018 and 2019 drag and drop the measures in the line values that will work

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[parry2k]

@Anonymous you can add 2nd measure in line chart,.