Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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.
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.
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.
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |