How can I hide the line part with no data?

[EugenioProlog]

Hello! I have this bar and line chart and I want it to not show the line part on months where there is no data. (Note that I dont want to hide the month, just want it to not create a fake trend line between the months). How can i do that?

[jdbuchanan71 · Accepted solution]

I don't know of a way to hide the 0 values but keep the line between the months with amounts but, you could turn on markers and set the line to transparent which changes the view to look like the 2nd chart.

[MFelix]

Hi @EugenioProlog ,

Since you are using the date this uses a continuous axis to achieve what you want you need to add teh UYear / month as an hierarchy on the axis and select the  show items with no data: