Forum Discussion

Tas1's avatar
Tas1
Advocate I
8 years ago

Line chart plotting in-existing data

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?

 

 

Need Help

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    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's avatar
      Tas1
      Advocate I
      8 years ago

      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's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi Tas1,

         

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

         

        Best Regards!

        Dale