Good day, dear all:
Can you please help me with a line chart from simple data below? The goal is to have a line chart to show the vairations when different filters applied. I tried to adjust the data types and sum counts both on both x-axis and y-axis, but anyhow it presents a flat line.
Thank you.
link to .pbix file: https://limewire.com/d/85c6f649-8f3c-4920-b059-e1d0ee608568#pi9DCjFS5BWxcGqwt9Jwgmd3WKEtEWCvLGk9FaKP... (expired on 11th March 2025)
YearProductAreaCodeStatusIDQty
| 2020 | 938 | MEDI | GR | Cancelled | g125 | 1 |
| 2020 | 938 | NP | BR | Closed | n747 | 1 |
| 2020 | 962 | NP | UK | Cancelled | y922 | 1 |
| 2021 | 962 | NP | UK | Closed | y325 | 1 |
| 2021 | 938 | EA | IN | Cancelled | n47 | 1 |
| 2021 | 938 | EA | IN | Cancelled | m100 | 1 |
| 2020 | 938 | MEDI | GR | Cancelled | g1256 | 1 |
| 2020 | 938 | NP | BR | Closed | n7475 | 1 |
| 2020 | 962 | NP | UK | Cancelled | y9221 | 1 |
| 2021 | 962 | NP | UK | Closed | y3252 | 1 |
| 2021 | 938 | EA | IN | Cancelled | n478 | 1 |
| 2021 | 938 | EA | IN | Cancelled | m1000 | 1 |
Hi @JohnnyK
The graph is flat accorsing to the data that you have...same number of id's every year :
in other filtering scenarios you have some differences and the line is changing according to them
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @JohnnyK
The graph is flat accorsing to the data that you have...same number of id's every year :
in other filtering scenarios you have some differences and the line is changing according to them
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
