the data is not showing correctly in the Line Chart visual

[topazz11]

data is missing from line chart but shown in table.

The data isn’t displaying correctly in the Line Chart visual. I created a table, and all of the values in the visual come directly from that table—no measures are being used. For example, the value "Ph0 of Total" shows a count of 22 in the data table, but only a few points appear in the line chart. please see attached pbix file.

Could anyone help me understand why this is happening and how to fix it? thank you

pbix file 

[v-aatheeque]

Hi @topazz11 

We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.

[v-aatheeque]

Hi @topazz11 

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

[danextian]

Hi @topazz11 

The line chart does it what is expected of it. The data has to be aggregated one way or another based on the legend and x-axis columns. Your table shows 22 rows because percent is not summarized.  

[d_m_LNK]

Essentially the graph is doing what you are telling it to evaluate right now as the Y axis is the PCT and the Legend is the ID.  Since each ID is unique each will have a count of one and reflect their percent from that column.  If you are wanting the chart to count the total like the chart you will need to create a measure.  It should be a simple measure like:

Count of ID = distinctcount(ID)

You could also average your PCT column in a measure so that it will aggregate those together: Avg of PCT = Average(Pct)

With those measures you can use your ID as the X or Y axis and then measure the count or average percent by ID.  I suggest making sure you have an X and Y axis defined in the visual to make it meaningful.  Making simple measures will help show those results better.  

[Ashish_Mathur]

Hi,

A line chart is created to show a trend and therefore that is not the appropriate visual for your data.

[Hongju_Jung]

Hi, @topazz11 

This is because Pct is treated as a total in the Line chart. 

At the table, there's also a way to convert the summary of Pct into total.

Thanks,

Hong

[MasonMA · Accepted solution]

Hi, 

That's because the Pct for Items in your Tooltip have been aggregated and the Pct value in Tooltip are not reflecting each single one of them. If you are looking to see the distributions i'd recommend using Scatter chart instead.

[topazz11]

I tested this using a scatter chart. Is there a way to add reference lines that show the target range for each value on the X-axis—for example, 100% and –100% at X = 0, and 50% and –50% at X = 1? or other visual i need to use it for?

@danextian @Ashish_Mathur @Hongju_Jung @d_m_LNK