Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

X-axis field missing in column chart

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

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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