Forum Discussion

jkhan's avatar
jkhan
Helper III
5 years ago
Solved

Help in Visual

  It is possible to create above visual where we have distribtion as per month and year
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    jkhan , With year and month on axis. you should have that. Expand till month level. If needed use concatenate label in format.

    Make sure Month sort on month no

    Month = FORMAT([Date],"MMM")
    Month No = FORMAT([Date],"MM") //month sorted on this column

     

     

amitchandak's avatar
amitchandak
Super User
5 years ago

jkhan , With year and month on axis. you should have that. Expand till month level. If needed use concatenate label in format.

Make sure Month sort on month no

Month = FORMAT([Date],"MMM")
Month No = FORMAT([Date],"MM") //month sorted on this column

 

 

  • jkhan's avatar
    jkhan
    Helper III
    5 years ago

    Hi Amit I tried your steps but its showing only year for me 

  • jkhan's avatar
    jkhan
    Helper III
    5 years ago

    HI Amit,

     

    can you please explain what do you mean by "Expand till month level"

     

    Best Regards

    Jamsher

  • jkhan's avatar
    jkhan
    Helper III
    5 years ago

    Hi Amit,

     

    Thank you very much for your assistance. I figure it out. Now i can see desire output. 

     

    Thanks Again.