Forum Discussion

fahadraza's avatar
fahadraza
Frequent Visitor
5 years ago
Solved

Month Name missing in between in Stacked Bar

Hello Everyone,

 

I am facing an issue that the chart is missing the name of the month in the axis as can be seen below i.e. August is missing after July and so on. Month name is coming from the column which is the concatenation of year and month from the date table and then formatted as the date. Please help on this and share your expert advice. 

 

Mname= Fiscal[CAL_YEAR] & "-" & Fiscal[Calendar_Month_NAME]

 

 

Thank you.

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    fahadraza , this usually happens with a continuous axis not with a categorical, this seems like a categorical axis.

    Any ways check exis type and make sure it is categorical

     

     

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    fahadraza , this usually happens with a continuous axis not with a categorical, this seems like a categorical axis.

    Any ways check exis type and make sure it is categorical

     

     

     

    • fahadraza's avatar
      fahadraza
      Frequent Visitor
      5 years ago

      Thank you amitchandak  issue is resolved I have sorted my visual by column name it's working fine.

    • fahadraza's avatar
      fahadraza
      Frequent Visitor
      5 years ago

      Thank you for your reply. 

      When I changed it to categorical it is changing the sort order, further previously it was continuous and working fine. Reference the picture below.