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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
v-xiandat-msft
Community Support
Community Support

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
v-xiandat-msft
Community Support
Community Support

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.