Re: Line Chart

pxg08680 · ‎10-26-2017

Looking through the image above, my chart shows value for different currencycodes.

Problem is I need the left side space to be removed, i.e., space between X-axis beggining and Europe Only. Same for WorldWide and Axis ending. I want the chart width to be same as I am using now.

One more preoblem is , Is there a way to show Currency Code as data label along with values.

Example in Europe only there is a black bar with value -6.5%. Can it be shown like -6.5% (ABC) where ABC is Currency Code.

I really need a help in this.

Thank You

Anonymous · ‎10-27-2017

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

pxg08680 · ‎10-27-2017

@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

Anonymous · ‎10-30-2017

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

pxg08680 · ‎10-31-2017

@Anonymous

My data doesn't have any blank or null values. In background sql I filtered out eveything.

Anonymous · ‎11-01-2017

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