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

     

     

4 Replies

  • 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.