TABLE DISPLAY PROBLEM - CONNECTING TWO TABLES

[Elie_HUCHET]

Hello,
I would like my stock dumpsters for 0 to show up in my chart. Let me explain.
It looks like it doesn't work because my array takes two data sources.
Indeed, I have a date source which is an Excel export where there are certain types of skips with the quantities. Then there is a second which is a power Bi database where there are all types of dumpsters. As on the Excel export there is a stock at 0 for some skips, they are not displayed in my export.

Example with the "OP 15" skip, in my export there is no stock therefore the stock is not displayed, except I would like to have the number 0. Even with the "display zero values" function it does not work because it is a formula.

I tried everything.. If you can really help me because here I am really desperate

[Elie_HUCHET]

I solved my problem but thank you for your help !! 🙂 

[v-jayw-msft · Accepted solution]

Hi @Elie_HUCHET ,

What is the last column in the screenshot? I'm not sure if I understood you correctly but you may consider to add "+0" at the end of the [export] formula, so that it will return 0 at blank records.

Best Regards,

Jay