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.

Anonymous , it is continuous axis, so showning blank should work new measure = if([measure]=0, blank(), [measure])

Line chart show lines without zeros | Microsoft Fabric Community

amitchandak
Super User
5 years ago
Anonymous , it is continuous axis, so showning blank should work

new measure =

if([measure]=0, blank(), [measure])
Anonymous
Not applicable
5 years ago
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)
Rafgva
Frequent Visitor
5 years ago
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
Not applicable
5 years ago
Yes however i need the months, because then they can filter in another line so there can be 2 lines. see below please