Forum Discussion
How can i keep charts continuous and remove weekend gaps?
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.
Super UserHi 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)