X-axis field missing in column chart

[Anonymous]

This issue has randomly popped up and was not an issue at first.  

One of the months that should appear in my column chart is missing from the visual. Not sure why. This has been clicked to be included in the graph. 

Please see below screenshot. Highlighted in yellow is the field 'June 2022' which should appear where the red arrow is pointing-before July 2022.

Why is this missing? 

Really appreicate the help. Thank you. 

Christiana

[amitchandak]

@Anonymous , is there any data for that month, If there is no data then that month will not appear

you can try a measure like

0 between range
Measure = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))

[Anonymous]

Hi @amitchandak 

Thank you for your response. There is defintely data for the month. 

There are 15 items as you can see in the screenshot under the month. 

Is there another issue that is restricting it to be included in the visual? 

Christiana