- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

How to prevent a line chart from showing months with no data
What is the mistake?
Thanks for the support.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Josevolquez85, if the post I provided solves your issue, can you kindly accept is as the solution to allow other Community members to search for it if they experience the same challenge.
Thanks heaps in advance.
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you TheoC,
Despite using the categorical option, I can't see all the data in the graph without having to scroll.
I need solve this to close the issue, please.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Josevolquez85 your X Axis should be using the Calendar table as the basis. Currently, you're using it from your Data table. From here, switch the settings back to CONTINUOUS instead of CATEGORICAL.
Let us know how that goes.
Thanks,
Theo 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

The issue you're experiencing is because the X-Axis is set to "Continuous" rather than Categorical.
Change it to Categorical and this will correct the issue.
The context of the above is because fields or columns that are DateTime or Date or Time can be "continuous." Power BI offers the ability to have these fields represented as "Continous" (i.e. uninterrupted) or on a "Categorical" basis (i.e. whatever exists in the data).
Hope this helps.
Theo 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
04-29-2024 01:23 AM | |||
02-14-2024 04:35 AM | |||
09-21-2023 11:02 PM | |||
04-10-2024 09:31 AM | |||
12-28-2023 05:16 PM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
47 |