Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
jtmag1
New Member

Column chart adding dates not present in data

I'm putting together a dashboard for call center data where the centers in question are not open on Sundays.  I've imported the data from a spreadsheet where there isn't a row for Sundays (picture attached).  In Excel, the bar charts just don't include dates that aren't there.  In PowerBI, the visualizations are automatically adding in a column for the dates not present with a blank/0 value.  In the attached images, the date being added is Sunday Apr 16.  

 

I've made sure that "Show items with no data" is not checked.  I've tried to set various filters to only show data where the value is greater than 0, or is not blank/empty.  Nothing seems to work to remove those columns.

 

PowerBIexample.JPGPowerBIexample2.JPG

1 ACCEPTED SOLUTION
v-haibl-msft
Microsoft Employee
Microsoft Employee

@jtmag1

 

Please go to Format pane - X-Axis - Type, change from Continuous to Categorical.

 

 

Best Regards,
Herbert

View solution in original post

2 REPLIES 2
v-haibl-msft
Microsoft Employee
Microsoft Employee

@jtmag1

 

Please go to Format pane - X-Axis - Type, change from Continuous to Categorical.

 

 

Best Regards,
Herbert

Thank you very much @v-haibl-msft.  Problem solved.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.