Forum Discussion
Line Chart Question and X Asis
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?
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.
I was able to create a calendar table and use Year from there.
5 Replies
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....
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?
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?
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.
I was able to create a calendar table and use Year from there.
