X-Axis Remaines the Same grouped column Chart

[bektasb]

I have my date hierarchy on the X-axis and my time period on the Y-axis, which I determined using the formula datediff. Using the Datediff formula I was able to determine the lead time of my products.

If I display it in a table it shows me the duration, for example (22 days, 30 days...)but not in the column chart

Here the diagram always shows me the same data for each time (the sum of the total lead time)

How can I enable it to show me the average values in the diagram. 

I have already selected Average for the x-axis but nothing has changedI would like the table to show me the average day values

[Idrissshatila · Accepted solution]

Hello @bektasb ,

I believe it's a relationship issue, there's no relation between the table that has the dates and the table that the values are coming from. 

[Ritaf1983]

Hi @bektasb 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523