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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Continuous line is coming in line chart , whereas there is no data in between.

I am facing a problem during working in line chart. The line is coming as continuous whereas there are some blank cell or the cell value is zero . 

I want to showcase the line as discontuous line. Please help on this.

Sample file is attached.

5 REPLIES 5
Anonymous
Not applicable

hi @Anonymous 

Here, is a Non-continuous line chart where you can put your broken data in a line chart and get an appropriate result.Non Continuous Line chart. pbivizedit.comNon Continuous Line chart. pbivizedit.com

 

Download link for the custom visual file on this page,

https://pbivizedit.com/gallery/non-continuous-line-chart 

 

This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

  • anyone, irrespective of technical skills, can create their visuals
  • 15 minutes to create a visual from scratch
  • opens up many additional attributes to edit (e.g. labels, tooltips, legends position, etc)

Give this a shot and let us know if you face any problems/errors.
You can use the editor to modify your visual further (some modifications cannot be done in the Power BI window and have to be in the editor).

 

Thanks,
Team PBIVizEdit

 

v-yangliu-msft
Community Support
Community Support

Hi  @Anonymous ,

You can replace the two Values with two Measure respectively:

Measure_Corrected SWL/Ground Water Elevation =
var _max=MAX('MR-209A'[Corrected SWL/Ground Water Elevation])

return

IF(_max=BLANK(),0,_max)
Measure_Temperature =

var _avg=AVERAGE('MR-209A'[Temperature])

return

IF(

    _avg=BLANK(),0,_avg)

 

Best Regards,

Liu Yang

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

Anonymous
Not applicable

@amitchandak  

Hi, I need your help . 

Anonymous
Not applicable

Hi, 

After selecting the type as Categorical, the line chart figure is showing straight line only . It is not working . Is there any other method? sample file is attached

Line Chart Test File 

amitchandak
Super User
Super User

@Anonymous , MAke axis type as categorical and try

 

Axis_type.png

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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