Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date Range incorrect

Hi All, 

 

I have a stacked bar graph and the x-axis pulls from the Date column in DimDate table. However, it's showing every single date up until the Max date in my Proposal table. Is there a way i can get my Dates on the x-axis to only show the Dates that exist in my Proposal table without pulling in the Date column from the Proposal table?

 

For example, i need to pull in the Date field from DimDate, however, instead of it showing 1/1/21, 2/1/21, 3/1/21 .... I want it to just show the indiviudal dates that exist in the Proposal table (i.e. 1/1/21, 20/1/21, 30/1/21...) 

 

Do i need to create another column in DimDate that brings the dates from the Proposal table?


Thanks all

1 Reply

  • Anonymous , check you axis type. Change it to categorical and try