Forum Discussion

brinky's avatar
brinky
Helper IV
7 years ago
Solved

Line chart

Hello,

 

Tha chart attached is showing year vs month for 1 brand, any idea how I can create a line chart showing 3 brands wih year and monthly performace.

 

Thanks,

Steve

 

 

 

 

  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi brinky 

    Another method is to import a custom visual Power KPI from marketplace.

    Create measures

    2018 = CALCULATE(SUM(Table1[data]),FILTER(Table1,Table1[year]=2018))

2019 = CALCULATE(SUM(Table1[data]),FILTER(Table1,Table1[year]=2019))

    Under Format->line, select each brand name, apply color for it.

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi brinky 

    Another method is to import a custom visual Power KPI from marketplace.

    Create measures

    2018 = CALCULATE(SUM(Table1[data]),FILTER(Table1,Table1[year]=2018))

2019 = CALCULATE(SUM(Table1[data]),FILTER(Table1,Table1[year]=2019))

    Under Format->line, select each brand name, apply color for it.

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi brinky 

    I have this kind of table structure, when adding "brand" column in a slicer, i can show 3 brands wih year and monthly performace.

    Is this something as expected?

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.