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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
mybonniewong
New Member

How to change the line chart to display multiple month

How to change the line chart to display multiple months.

I have tested the X and Y axis in the blank page, it can show multiple months; however, it can only show max 2 month in the page. Any idea to set it correctly.

 

The chart can only show 2 monthsThe chart can only show 2 months
Desire chartDesire chart

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi  @mybonniewong ,

Thank you for@ChiragGarg2512 answer, and I have other suggestions:

If your chart is only showing a maximum of two months, it's possible that the data model or the filters applied to your visual are limiting the data being displayed. Ensure that your data model includes all the months you wish to display and that there are no filters inadvertently restricting the view to just two months.

Sometimes, the visual itself might need adjustments to properly display multiple data points or ranges. If your data points for the months are very close or very far apart in value, consider using a combo chart or adjusting the Y-axis to better accommodate the data ranges.

Below is the official link will help you:

Create line charts in Power BI - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi  @mybonniewong ,

Thank you for@ChiragGarg2512 answer, and I have other suggestions:

If your chart is only showing a maximum of two months, it's possible that the data model or the filters applied to your visual are limiting the data being displayed. Ensure that your data model includes all the months you wish to display and that there are no filters inadvertently restricting the view to just two months.

Sometimes, the visual itself might need adjustments to properly display multiple data points or ranges. If your data points for the months are very close or very far apart in value, consider using a combo chart or adjusting the Y-axis to better accommodate the data ranges.

Below is the official link will help you:

Create line charts in Power BI - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

I have fix it with your suggestion, thank you!

ChiragGarg2512
Super User
Super User

Try changing the type of x-axis from categorical to continuous or vice versa.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.