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