Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Line chart trouble shooting - won't display joined table correctly (.pbix example file attached)

I have a line chart that won't display how I want. See attached .pbix file as example. I have one table that is shipments data. Another table that is a goal table. The two tables are lnked by a date table.  I want to plot the shipments by day and the goal by day. The shipments line correct is correct as it show the number of units shipped each day. The goal line is just flat as it's showing the average of all the days but it should show the goal (which changes) for each day. The below picture shows what I want (the flat dark blue line at the top should be like the red line that is drawn)

 

Here is the .pbix file:  pibix file