Forum Discussion
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
Anonymous , check you axis type. Change it to categorical and try
1 Reply
- amitchandakSuper User
Anonymous , check you axis type. Change it to categorical and try