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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.