Forum Discussion
Helper IIIGraph shows data for each 3 days
Hello community,
Alle
I build a graph wich show the use av anergi vs. day / month / year. I am using parameter to make a slice on day/ month/ year. Data set has data for alle days but when I shows it in graph , it shows only each 3 days and the fouth day is empty. I changed from the graph to table it show data for alle days.Can anyone helps to show me why it happen? Thank you!
Hi HaiVN,
Thank you for reaching out to the Microsoft Fabric Forum Community.
The issue you're facing, where every fourth day is missing from your bar chart despite having data for all days, is likely due to the x-axis settings in your Power BI visual. When the x-axis is set to "Categorical," Power BI may skip dates for better visual spacing, especially if the data points are dense. To fix this, change the x-axis type to "Continuous," which ensures all dates are displayed in sequence, including those with zero values. Additionally, make sure you're using a proper date table marked as a date table in your model, and that it's correctly related to your data. This approach ensures accurate and complete time-based visualization.
If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.
Thank you & regards,
Prasanna Kumar
3 Replies
- grazitti_sapna
Super User
Hi HaiVN,
Power BI charts (especially line charts or area charts) have two options for the x-axis:
-
Continuous (default) — tries to auto-scale dates like a number line, and may skip days if gaps exist or to optimize display.
-
Categorical — treats every single date as a separate category (even if spacing looks weird), so no missing days.
Follow below steps to fix it
-
Select your graph
-
Go to the Format pane (paint roller icon 🎨)
-
Expand the X-axis settings
-
Look for Type → Change from "Continuous" to "Categorical"
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together! -
Hi HaiVN,
Thank you for reaching out to the Microsoft Fabric Forum Community.
The issue you're facing, where every fourth day is missing from your bar chart despite having data for all days, is likely due to the x-axis settings in your Power BI visual. When the x-axis is set to "Categorical," Power BI may skip dates for better visual spacing, especially if the data points are dense. To fix this, change the x-axis type to "Continuous," which ensures all dates are displayed in sequence, including those with zero values. Additionally, make sure you're using a proper date table marked as a date table in your model, and that it's correctly related to your data. This approach ensures accurate and complete time-based visualization.
If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.
Thank you & regards,
Prasanna KumarHi HaiVN,
We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.
If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution — it helps others who might face a similar issue.
Warm regards,
Prasanna Kumar
