HowTo: Create line graph with text labels and dates

[Kapako]

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

Just like folowing example (=mockup):

[vanessafvg]

@Kapako just enabled the data labels in the settings

[Kapako]

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]

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? 

Regards

[Kapako]

Thanks for trying to help, but unfortunaltely GANTT is able to add the tasks to Y-axis but on X-axis not able to plot dynamic point in time. On X-axis it plots block from date 1 to date 2 and the progress.

Projected on tasks, what I am looking for is sort of a status for a task in time, which can be any value from my list without any dependency.

Looking further now and will also post it to the 'Wish' List.

Regards