Line Chart Question and X Asis

[bdehning]

Ok here is a Line Chart and table of data on the Line Chart.  How do I get Claims Per Mil values to line up with Policy Year Values or can I? 

[bdehning · Accepted solution]

I do see the issue but not sure how to correct it.  My Year Dates used for the X Axis are not all 1/1.   The Year Dates can start on any day of the year and why the X AXis is shifting when I use Continuous.     

[bdehning · Accepted solution]

I was able to create a calendar table and use Year from there.   

[RKM]

Although its alway great if you can share a PBIX to check. But I believe I could reproduce you issue....

And luckily there are many ways to address it.

Step1 - You first Convert your INCEPTIONDATE to "DD MMM YYYY" format just to double check if its showing 09th Jan  Or 1st Sep.... I believe 2nd one is the case....  Because as you see your alignment of those datapoints are somewhere near 3rd Quarter.

Step 2 - To Address the issue - there are 2 very quick ways 

(Option 1) -  In your X axis where you selected INCEPTIONDATE --- Just select INCEPTIONDATE Hierarchy (as you know if its date or datetime column this will appear as an option)

Or

Option (2) - You simply change your X axis Type to "Catagorical"   instead of Continuous,

Let us know if any luck....

[bdehning]

Categorical works for Line Chart and Line and Clustered Column Chart.    Is there any way to add a Trend Line and keep the Year under the Calculated Claims Per Million?

[bdehning · Accepted solution]

I do see the issue but not sure how to correct it.  My Year Dates used for the X Axis are not all 1/1.   The Year Dates can start on any day of the year and why the X AXis is shifting when I use Continuous.     

[bdehning]

Whats stranage to start with is that I change the Inception Date to what ever format I want and it keeps showing the X Asis as YYYY.  I even deleted the visual and started with a new one after changing Inception Date Field to mm/dd/yyyy and still it shows YYYY dates?  Any idea why?