Line Chart displaying count instead of actual value in direct query

[tina345]

Hi gurus,

   I am trying to use a line chart, however value is coming as count instead of actual value.

   I am using direct query from Oracle database and that field is converted to number in Oracle.

   Could you please help?

Thanks

[v-yalanwu-msft]

Hi, @tina345 ;

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,

Community Support Team_ Yalan Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi， @tina345 ；

You could change the values to "Count of " or "Discount of" ,such as:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@tina345 , if you use a column on values it will take some aggregation.

If the data type text, change it column tools and try a different aggregation like sum.