Forum Discussion

stokidez's avatar
stokidez
Helper III
5 years ago
Solved

Table not showing results from Line Graph

I have the following line graph in my report which shows the number of projects due to start and finish.

 

 

The two values in the line graph are setup as such:

Planned Project Start Date Count = CALCULATE(COUNT('Procurement Plan (2)'[Id]),USERELATIONSHIP('Procurement Plan (2)'[Planned Project Start],'Date Table'[Date]))
 
Planned Contract Signed Date Count = CALCULATE(COUNT('Procurement Plan (2)'[Id]),USERELATIONSHIP('Procurement Plan (2)'[Planned Contract Signed],'Date Table'[Date]))
 

The Planned Contract Signed and Planned Project Start Dates are linked to a Date table as shown below:

 

When I select the line for Planned Contract Signed Date, the respective table shows the results which aligns to the number in the line graph. In this example, 2 on the line graph, and 2 records show in the table.

 

However, when I select the line for Planned Contract Start Date, the respective table never shows any records. 

 

Any help much appreciated!

Need Help