Stacked Line Chart, how to stop line from continuous

[kala2]

I have a Stacked Line Chart which displays data by month

DAX Red Line Measure is: 

MeasureRedLine = SUM(Costs[value]) + 0

I want to remove the empty gap between months and stop the red/orange line to continuous until a new value.

Expected Result:

Or even Better if we prevent line to continuous when bars end like:

Any ideas how to achieve that?

[Mayank_Yavda]

Hi @kala2  ,

here is Stacked Column chart with Non Continuous Line Chart which will help you to get the non-continuous line for parts where there is no data or values.

Stacked Column Chart with Non-Continuous Line Chart, PBIVizEdit.comStacked Column Chart with Non-Continuous Line Chart, PBIVizEdit.com

Download link for the custom visual file in this page,

https://pbivizedit.com/gallery/stacked-column-chart-with-non-continuous-lines 

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

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

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

Thanks,
Team PBIVizEdit

[jaipal]

@kala2  in your filters tab,  unselect Blank like as follows

[kala2]

@jaipal 

My Shared axis is 

And i dont have blank values in Year or Month 

[jaipal]

@kala2 do you have date table? if yes, change cross filter direction to Single.