Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mrgonzal
Frequent Visitor

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.ayuda.PNG

 

 

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 4
mrgonzal
Frequent Visitor

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

v-yanjiang-msft
Community Support
Community Support

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:

vkalyjmsft_0-1665742509732.png

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

Result:

vkalyjmsft_1-1665742551982.png

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
Frequent Visitor

Thank you very much for your help
TomMartens
Super User
Super User

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
 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.