Forum Discussion

Tas1's avatar
Tas1
Icon for Advocate I rankAdvocate 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
Icon for Microsoft Employee rankMicrosoft 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
Icon for Advocate I rankAdvocate 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?