Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Thank you very much for your support, I need the line not to be drawn
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.
Thank you very much for your help
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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |