Forum Discussion
Line Chart
HI pxg08680,
>>Problem is I need the left side space to be removed
Based on your screenshot, these blank records occupate left part of chart, right?
If this is a case, current clustered column chart not support customize x axis or hide blank category.(these graphs are generated by categories and records, you can't customize it)
>>One more preoblem is , Is there a way to show Currency Code as data label along with values.
Current only pie/donut chart support shows detail informations on data label, clustered column chart not support yet.
For your requirement, you can submit this to ideas forum.
Regards,
Xiaoxin Sheng
Anonymous
Thanks for replying.
I tried to CONCATINATE my value column with my Currency Code column. But this all gives me a data type as text. This is working perfectly if I represent them as a table visual but not working for a Line Chart.
Can it be done this way..?
Thank You
Hi pxg08680,
>>I tried to CONCATINATE my value column with my Currency Code column.
Line chart not support use string value in value fields, even if you force drag text column in it, the column will switch to summary mode 'count.
In my opinion, I'd like to suggest you to create new table with filter non-blank records. Then you can use filtered table as the source of line chart.
Regards,
Xiaoxin Sheng
Anonymous
My data doesn't have any blank or null values. In background sql I filtered out eveything.
Hi pxg08680,
If you table not contains blank records, you can try to manually setting the start point of x axis.
Update: it seems like custom start point feature only works when you used date type on x axis, numeric type on y axis. If you want this feature support more type, you can submit this to ideas forum.Regards,
Xiaoxin Sheng