Forum Discussion
Problems in continuous axis line graph that does not interrupt where there is no data
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
4 Replies
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
Thank you very much for your helpHi 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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for your support, I need the line not to be drawn
