How can i keep charts continuous and remove weekend gaps?

[Lucasselle]

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.

 

[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.

[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]

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.

[danextian · Accepted solution]

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. 

[Royel]

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!

[Lucasselle]

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)