Repeated labels on chart axis

Question

Summary

Content

Does anybody know why this might be happening?

--     simple XLS as a Data Source - One description Column and a number Column (Number summed, values eith 1,2 or 3)

--     When I create a barchart of any type it shows two entries per number

so my X Axis on a horizontal bar is showing 1,1,2,2,3,3 when it should be showing 1, 2, 3

Same affect if flipped to Y axis...

Is this a bug?

I've tried:

--     Changing it to plane CSV after moving through a Data Flow

--     Changing it to two different CSV's (Dim & Fact and toggled SUM on the number)

Still no joy..... I'm missing something here....

Stephan Reyher-Oracle · Answer

Hello,

you need to modify the formatting of the value axis. By default this is set to "no decimals". In your case, you need to set to at least one decimal (0.1).

This will solve your issue.

FTisiot · Answer

hi Ciaran,

Are you sure there are no trailing spaces in your description column e.g. "1" and "1 " are treated differently