Search code examples
reportpowerbipowerbi-desktop

PowerBI skipping month in bar chart

I have created the attached dashboard in powerBI. It is a monthly report. That shows the count of item each month. The dates are in this format 1/1/18, 1/2/18, 1/3/18 that the first day of every month When I created the report powerBI are skiping one month at interval. See Pix attached. how can i show all months? enter image description here

Desired enter image description here

Solution

  • I believe you'll need to change the "X-Axis" type to "Categorical". It looks like it's defaulting to Scalar, which makes a continuous axis and picks tick marks based on available space.