Line chart

[brinky]

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 · Accepted solution]

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.

[brinky]

Hi @v-juanli-msft ,

Thanks worked like a charm, well done.

Regards,

Stephen

[v-juanli-msft]

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.