Show null line in line diagram for not existent data

[Jonathan_25]

*** feel free to answer in English or German ***

Hi Community,

I need help with my current Power Bi diagram.

I have a data table giving information about pickup dates and volume/weight information for multiple shipments.

I want to visualize volume and weight by pickup date in a line graph - easily done.

Here a picture of what I mean (only volume in this graph):

As seen, there is no data between mid/late Dez 23 and early Jan 24.

The line graph fully "ignores" that as the line just connects the values.

I'd need the line to go to 0/null when there is no data instead of just jumping to the next data point.

Null data is not represented as rows in the table so there is no option to calculate an actual 0 when there is no data

Anyone has an idea whether there is an option to do this or a setting I missed?

Thank you in advance and best regards,

Jonathan

[rubayatyasmin]

Hi, @Jonathan_25 

Assuming you have a date table created and connected to your fact table. To handle missing data, you need to create a measure like

Adjusted Volume =
IF(ISBLANK(SUM('Table'[Volume])), 0, SUM('Table'[Volume]))

add this measure to your viz. this should draw a line to 0 at least instead of blank point.