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
dancarr22
Helper V
Helper V

Line chart - show dates at a given interval on X-axis

Hello,

 

We have a Power BI Report with a line chart on it.  The X-Axis is a date field.  By default the (X-axis) Type is 'Continuous' and shows Jan-2024, Feb-2024, etc as the X-axis values.  Please see screenshot below for example.

But, our users want the X-axis to display 1/31/2024 2/28/2024, 3/31/2024, etc - month-end dates. 

We do have a 'month-end date' field in our Dates table - tried adding that but didn't work - kept repeating same month-end date for every day of the month.

Also, have changed X-axis Type to 'Categorical' but then it also displays every date.  Need to set some interval to only show every month.  

How can this be done?  Seems like it should be possible.

 

 

Thanks,

DanSCreenshot.png

 

 

1 ACCEPTED SOLUTION
PIYUSHPRAJAPATI
Resolver I
Resolver I

PIYUSHPRAJAPATI_0-1719214575002.png

DAX: 

ENDDATE = EOMONTH(Orders2014[Order Date],0) and Just change the Categorical Instead of the Continuous.

 

View solution in original post

2 REPLIES 2
PIYUSHPRAJAPATI
Resolver I
Resolver I

PIYUSHPRAJAPATI_0-1719214575002.png

DAX: 

ENDDATE = EOMONTH(Orders2014[Order Date],0) and Just change the Categorical Instead of the Continuous.

 

HotChilli
Super User
Super User

I'm reasonably sure 'categorical' is the right choice with the EndOfMonth field in the x-axis field well.

Can you show what happens when you try that + a small data sample so I can test please?

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