Line chart show lines without zeros

[Anonymous]

Hello there,

hope you are well,

I do not want to show value 0s because it cause dramatic increase/decreases in my line chart.

Can you please help.

[amitchandak · Accepted solution]

@Anonymous , it is continuous axis, so showning blank should work

new measure =

if([measure]=0, blank(), [measure])

[Anonymous]

Yes however i need the months, because then they can filter in another line so there can be 2 lines. see below please

[Rafgva]

Hello,

Would be easier if you give some sample data, but as I see it now:

Create a measure to be used in the chart:

.Values-skipping-zero =

CALCULATE(

    MAX('YourDataTableName'[YourDataColumn]),

    'YourDataTableName'[YourDataColumn] > 0

)

...and use it for the chart in 'Values' field.

Your thumb up if that helps will be appreciated.

[Anonymous]

A point on a line consists of an x and and y 

You could remove the point (which means you dont show the months where the values is 0)