How to change the line chart to display multiple month

[mybonniewong]

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 months
Desire chart

[v-xiandat-msft · Accepted solution]

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.

[mybonniewong]

I have fix it with your suggestion, thank you!

[ChiragGarg2512]

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