Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bdehning
Post Prodigy
Post Prodigy

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? 

 

bdehning_0-1687101967248.png

 

bdehning_1-1687101999468.png

 

2 ACCEPTED SOLUTIONS

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.     

View solution in original post

bdehning
Post Prodigy
Post Prodigy

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

View solution in original post

5 REPLIES 5
bdehning
Post Prodigy
Post Prodigy

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

RKM
Helper IV
Helper IV

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,

 

RKM_1-1687110635711.png

 

 

 

RKM_0-1687110351420.png

 

Let us know if any luck....

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.     

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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors