Forum Discussion
How can i keep charts continuous and remove weekend gaps?
How can I keep this chart continuous and remove the weekend gaps?
I need to keep it continuous because if I switch to categorical, it automatically creates a scroll bar and I can’t see the entire period.
Hi Royel
If you're referrring to the columns, there's no way to connect them other than to remove the weekends from the visual or fill the gaps with some numbers (but what would they be?). If the lines instead, they should be connected by default if x-axis is set to continuous even if there are weekend gaps.
7 Replies
- Royel
Super User
Hi Lucasselle In Power BI bar or column visual are not able to handle this gap when your x-axis is continues. If you are ok with categorical axis here is a quich solution
Step 1: Create a new column in your calendar table
IsWeekday = IF(WEEKDAY(Calendar[Date], 2) <= 5, Calendar[Date], BLANK())Step 2: Use this column in x axis and make x-axis as categorical
Results:
Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!
Hi Royel, if i change to categorical the scroll bar appears and i can't see all the informations bacause i can't reduce more the bars(20% is the limit)
- danextian
Hi Royel
If you're referrring to the columns, there's no way to connect them other than to remove the weekends from the visual or fill the gaps with some numbers (but what would they be?). If the lines instead, they should be connected by default if x-axis is set to continuous even if there are weekend gaps.
- Royel
Right, only option is to use time basd chart (line, area or so) or consider x-axis as categorical and without weekend date column.
v-ssriganeshCommunity Support
Hi Lucasselle ,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to Royel & danextian for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
- v-ssriganesh
Hello Lucasselle,
Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.
Thank you.
- v-ssriganesh
Hello Lucasselle,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
