Date Table values are not showing in the visual

[anjugauriunni]

I have an e-commerce dataset and created a date table using 'Bravo'. Both tables are connected, with the Date from the Date Table linked to the Order Date in the e-commerce dataset. However, the X-axis shows blank in the axis value when I try to populate a bar chart using the calendar hierarchy from the Date Table along with Total Sales from the e-commerce dataset. No values appear on the chart when I use the Date column from the Date Table instead of the calendar hierarchy. It is the same with a manually created date table. But the problem is only when dates are used. With category vs sales, the bar chart is showing correctly. Please explain

[Idrissshatila · Accepted solution]

Hello @anjugauriunni ,

please check if the date column in the data table is datetime, if it is then you need to convert it to date in Power query.

[anjugauriunni]

Yes, The order date column was in the wrong data type.  Corrected it and created the date table again. It is working now. Thank you very much.

[Gabry]

Hello @anjugauriunni ,

I can suppose something it's not working with your relation. Could you load sample pbix?

Have you tried directly using the order date column from the sales table?

[anjugauriunni]

Sorry, I forgot to mention.It is working properly when I use the order date column directly.