Help needed graphing a count between a date range

Sounds fairly straight forward.

Watch the guided learning - getting started videos.

https://powerbi.microsoft.com/en-us/learning/

1) Get Data

2) Connect to SQL

3) Select [Unique Serial Number], [Product Model], [Product Family], [Date sold], [Warranty Expiration Date], [Sold to Country] from your SQL DB. PowerBI can handle much more data than Excel so try without aggregationm but if your data is too big try grouping in SQL first.

4) Ensure you dates are Date types

5) add a 3 slicers for Product Model, Family and Date. Dates will default to a range slicer.

6) add a line graph with date on the axis ,SerialNo in values and Model in legend. Serial no will probably default to count. If not change it in the values by right mouse menu on the field.

Drill into the dates to see more detail or remove the hierarchy if you don't like it (right mouse on the date in the axis).

Get to this point then we can look at the other elements. Not sure about the warranty expiration date, Is this based on now or a selected date?

Also do you want a different line graph for country?

Maybe a scatter chart is better as you can have lost of deteail e.g. grouping, position, size and colour.