Forum Discussion
MSAYED26
Helper II
Helper IIneed help
Hello, I want to the chart continue the line to today , there is no value make it equal zero like chart below
Hi MSAYED26 ,
Sorry, I don't quite understand what you are looking for, can you add more description so we can better understand your problem?
Also, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MSAYED26Helper II
Helper IIThanks for your time, in count value that cell equal zero and ppm equal zero the target still have value ,so i want the target line continous have value not zero like green line .
| Count | PPM | Target | |
| May-21 | 2 | 210 | 166 |
| Jun-21 | 1 | 75 | 166 |
| Jul-21 | 2 | 190 | 166 |
| Aug-21 | 6 | 748 | 166 |
| Sep-21 | 0 | 0 | 166 |
| Oct-21 | 3 | 179 | 166 |
| Nov-21 | 1 | 62 | 166 |
| Dec-21 | 3 | 412 | 166 |
| Jan-22 | 0 | 0 | 166 |
| Feb-22 | 0 | 0 | 166 |
| Mar-22 | 0 | 0 | 166 |
| Apr-22 | 0 | 0 | 166 |
| May-22 | 0 | 0 | 166 |
| Jun-22 | 0 | 0 | 166 |
| Jul-22 | 0 | 0 | 166 |
| Aug-22 | 0 | 0 | 166 |
| Sep-22 | 0 | 0 | 166 |
| Oct-22 | 1 | 40 | 166 |