line graph error

[Amardeep100115]

Hi 
i am facing an error for line graph, i have given result line graph in BI file and the second graph which need to be like above one

BI File 

Excel File

[amitchandak]

@Amardeep100115 , what error you are getting is not clear with file. But what I got it That join is missing Nos table.

In that create a date using year

Date = Date([Year],1,1)

and join with date table

[Amardeep100115]

See below image 

second bar chart should be look like above one. below column is not getting filtered like above one, it should be reflact data by City Id and selected date period