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 d...
Need Help
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