Line Chart: How to show the lines when it has no values

[carloscabreraq]

Hello,

i have this measure  Sales = SUM(Sales[Quantity]),  Sales is my FactTable, and it is related to a DimensionTable  "Date".  When i try to use  this measure by date in a  Line Chart i get this result:

It doesnt show data when it has no values, in this case i want this result.

My X-Axis type is "Categorical" and the option "Show items with no data" is checked. how can i do this?

I didn't find a solution for this in the forum, thanks for your help.

Regards.

CACQ

[MFelix]

Hi @carloscabreraq,

What is happening is that when you don't have values on the sum of sales returns blank so no point is returned on the chart.

Change your measure to
Sales = SUM(Sales[Quantity])+ 0

This will force your value to return. 0 instead of blank and filling your chart.

Regards,
MFelix

[carloscabreraq]

hi @MFelix , when i do this, i get this (picture), it doesnt apply the filter for just 1 month. Why?

[MFelix]

Check if the axis is still on categorical.

[carloscabreraq]

@MFelix 

---

@MFelix wrote:
Check if the axis is still on categorical.

---

yes it is stil on categorical, btw i am using a slicer with this "period comparer" Period Comparator M

which is related to my date table.