Forum Discussion
brinky
7 years agoHelper IV
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
- 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
MaggieCommunity 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
7 years agoCommunity Support
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
7 years agoHelper IV