How to capture the data in line chart correctly

[k2nneth]

The left side table shows the data, and the right sideline chart to display each PNA result.

Finding:

1. 200-60, it shall capture 1 in PNA002, and 3 in PNA003, but 3 error for 200-60 is captured in PNA003 only.

The SN is repeating on both PNA tester but shall capture on each PNA result instead of only in PNA003.

[k2nneth · Accepted solution]

The issue has been solved by removing the filter and re-added in. 

[Anonymous]

Hi @k2nneth ,

You may try to put these measures into Filters in the visuals.

The measure in the PNA002 Total Mating Error vs Time:

PNA002 = IF(MAX('Table'[StationName])="PNA-002",1)

The measure in the PNA003 Total Mating Error vs Time:

PNA003 = IF(MAX('Table'[StationName])="PNA-003",1)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[k2nneth]

Hi @Anonymous 

Thanks for your suggestion. I tried but it wont work.

Before:

After

that blue in color (200-64) shall appear 1 in PNA002 and another 1 in PNA003, instead of 2 in PNA002. 

You may refer to table on the left.