Forum Discussion

Kapako's avatar
Kapako
Advocate I
8 years ago

HowTo: Create line graph with text labels and dates

Is it possible to create a line graph having text labels on Y-axis and dates on X-axis?

Just like folowing example (=mockup):

Need Help

4 Replies

    • Kapako's avatar
      Kapako
      Advocate I
      8 years ago

      Can you explain a little more?

       

      I have a date field as Axis and do not know how to handle the field with the text values.

      For each date the field with the text values contains values as shown in the mockup on the Y-axis.

      For example 2 fields like:

      [Date] : [Action]

      ...

      09/05/2017 : Sell

      09/08/2017 : Danger

      09/09/2017 : Danger

      ...

      09/25/2017 : Watch

      ...

       

      I tried to do the trick using a conditional field provisioning some integers (0-5), which indeed shows the graph as wanted though showing the numbers on Y-axis.

       

      Regarding your feedback:

      As far as I understand data labels shows the number, in this case the count, next to the line and I am not looking for that.

      Or do I misunderstand what you suggest?

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Microsoft Employee
        8 years ago

        Hi Kapako,

        I tried to do the trick using a conditional field provisioning some integers (0-5), which indeed shows the graph as wanted though showing the numbers on Y-axis.

        This seems to the best option here in this scenario currently. 

         

        In addition, could you try using the Gantt custom visual to see if it helps? :smileyhappy:

         

        Regards