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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Applicable88
Impactful Individual
Impactful Individual

Bar chart not showing all dates

Hello,

 

I have a table with date dimension starting from 2012, here is an example:

SerialnumberAvalueBvalueDate
1234561001.01.2012
1234571002.01.2013
1234581003.01.2021
1234590104.01.2021
1234600104.01.2021
1234611006.01.2021
1234620106.01.2021
1234630108.01.2021

 

In the bar chart I count the serialnumber with specific condition base on the flags in the second and third column.

My problem is....why the barchart is only showing  me the count of all quarters, all month, 31 days of a month cummulated?

but not all dates available? 

When I set dimension to date it should show me the count of these days back to 2012, for each day.  Instead it shows me only the count of serialnumbers of a range of  31 days, apparently based on which same weekday it was,  accumulated of all those years:

 
 

Sample Power Bi.jpg

 

 
 

 

 

 

 

 

 

2 REPLIES 2
Anonymous
Not applicable

What happens if you turn on the switch for "Concatenate Labels"

You can find this setting in format options of the visual and then x-axis

Hello @Anonymous,

thank you very much so far. I'm one step further, when I switch from "category" to "concatenate labels". I don't know if I'm to used to Qlik or so, but is there nothing like a autocalendar in powerbi. I means like below the bar chart, where I can switch between different dimensions, e.g. dates, week year?

After concatenate is on its going to the whole range of dimension, but only something outside of the bar chart, like a slicer filter can zoom in specific date ranges. 

Is that how power bi works?

Thx. 

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors