Line chart plotting in-existing data

[Tas1]

Hi guys, I'm trying to plot in-existing data in a line chart, crazy?!! I'm trying to create an August-September trend, you can think of it as Products types being sold, obviously in some cases some data exists in Aug and not in Sept (some products sold in Aug and not in Sept) and vice versa, what I want to do in these cases is to evaluate it into a zero so that for all products I have a complete line ( meaning if the data does not exist then 0).

Help?

 

[v-jiascu-msft]

Hi @Tas1,

You can try a measure like this. If you want further help, please provide a dummy sample. The pbix file would be great.

Values =
VAR Total = SUM ( 'table'[quantity] ) RETURN IF ( ISBLANK ( Total ), 0, Total )

Best Regards!

Dale

[Tas1]

Great! thank you for your help @v-jiascu-msft, however it works for some of the values only as in the pic. any suggestions?

[v-jiascu-msft]

Hi @Tas1,

Could you please share a dummy pbix file? I can't think of anything from the pic.

Best Regards!

Dale