Date table shows values for years that aren't any values

[selected_]

I created a date table like this 

Date = CALENDAR(DATE(2020,1,1),DATE(2030,12,31))

and when I visualize with Margin % with this date it shows value until 2030 in the line chart. How's is possible? What are the wrong?

[v-shex-msft]

Hi @selected_,

What fields are you used to link these tables? Can you please provide more detial information to help us clarify this scenario?

How to Get Your Question Answered Quickly 

Did you use the new data table fields as the axis of your chart? If this is a case, raw table records will mapping to the 'blank' category if they out of current date table ranges.

Regards,
Xiaoxin Sheng

[darentengmfs]

@selected_ 

What happens if you put the date in the filter panel, with the criteria Margin % is not blank?

[pranit828]

HI @selected_ 

As you have dates till 2030 it is showing all. Nothing wrong.

What is the relation you have between these two tables.

Do you have cross filter direction both 

Try shanging it to single.

[selected_]

@pranit828 

It's single