Problems in continuous axis line graph that does not interrupt where there is no data

[mrgonzal]

Hello, I would like your support for the following situation:

I have created a line chart that shows values on the y-axis and on the secondary y -axis. On the x-axis it shows daily dates, therefore a continuous axis has been created since it must be able to display data from many years on a daily basis.

The only detail is that if the data on the axis y (normal o secondary) has no data, that is, it is blank, the line should not be drawn. That is, there must be an interruption of the line. I put example image.

the orange line enclosed in a purple circle should not be drawn because these days there is no data

Thank you very much for the support

[mrgonzal]

Thank you very much for your support, I need the line not to be drawn

[v-yanjiang-msft]

Hi @mrgonzal ,

Line chart represent the trend of the Y-axis with respect to the X-axis, it can't be interrupted.

As a workaroud, you can create a measure to change the blank value to 0. For example:

Measure = IF(MAX([Value])=BLANK(),0,MAX([Value]))

Result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mrgonzal]

Thank you very much for your help

[TomMartens]

Hey @mrgonzal ,

unfortunately, this is not possible for continuous axis.
I assume this is the concept of a continuous axis.
From my understanding, there is no relationship between the available ticks on the x-axis and the values used on the y-axis.

Consider creating or upvoting an idea on ideas.powerbi.com

Regards,

Tom