cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EliasMerabet
Advocate II
Advocate II

Showing dates in a LineChart

Hello Team,

I defined Items of the LineChart as:

Set(_Bar, Filter(Tareas, Aprobada && !Terminada && Planificada > DatePicker1.SelectedDate && Planificada < DateAdd(DatePicker1_1.SelectedDate,1, Days)))

Being the next configuration for the LineChart:

EliasMerabet_0-1634888122551.png

 

Planificada is a Date, and Title is a string

But when I paint the graph, the values of Planificada are numbers.

 

EliasMerabet_1-1634888210130.png

 


How can I achieve to get these values as their appropiates dates.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @EliasMerabet ,

 

Unfortunately, this is expected behavior. 

The line chart converts the date into a number, because its y-axis shows numbers.

The oob chart controls in canvas can only achieve some basic functions.

 

Best Regards,

Wearsky

View solution in original post

2 REPLIES 2
EliasMerabet
Advocate II
Advocate II

Trying this option:

 

 

ClearCollect(_Bar,AddColumns(Tareas,"Prueba",Text(Planificada, DateTimeFormat.ShortDate )));

 

 

Prueba doesn´t appear in Series options of the advanced settings of the chart, but it appears in the Collection


That doesn´t make any sense to me

v-xiaochen-msft
Community Support
Community Support

Hi @EliasMerabet ,

 

Unfortunately, this is expected behavior. 

The line chart converts the date into a number, because its y-axis shows numbers.

The oob chart controls in canvas can only achieve some basic functions.

 

Best Regards,

Wearsky

View solution in original post

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,523)