Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
Solved! Go to 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.
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!
Try changing the type of x-axis from categorical to continuous or vice versa.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
80 | |
64 | |
52 | |
48 |
User | Count |
---|---|
213 | |
89 | |
77 | |
66 | |
60 |