Line Chart with Direct Query not showing correctly

[Deea_cz]

Hi,

I am new to PBI and am creating a sales dashboard where i connected to my SQL database with Direct Query.

I wanted to create a historical chart for number of sales received (which worked when my data was imported but doesnt since i changed to Direct Query) , however my line chart seems to be a straight line with the total across each month  . I tried to create a date table but that doesnt seem to work either ,the chart just stays blank and i am not sure why. I dont know what i am doing wrong, any advice would be greatly appreciated. I am attaching the date format in my database below.

thank you

[Anonymous]

Hi  @Deea_cz ,

You can try the following dax:

Measure =
COUNTX(
    'Table',[SNumber])

Whether there are other tables in the Modeling View with relationships established, and whether "Assume Referential Integrity" is turned on.

Assume Referential Integrity setting in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.