Remove values from X axis for some bars in stacked chart

[saumyashah90]

I want to remove this -0 and -1 from X Axis

[saumyashah90]

any response?

[rushikale0106]

Hi Saumya,

Can you please explain your query a bit more? What these values are representing?

If any other case, You can hide the values from the Axes tab in chart properties. The one way I used, by making Axis font color values transparent or changing the color as per the background color.

In any way, let me know about the details issue.

Regards,

Rushika

[saumyashah90]

Hi Rushika,

I have 2 dimensions, 1 is month and other is category. months you can see on x axis and stacks are built out of categories. expression has sum of revenue.

I am not sure why i have -0,0,1 showing for some bar charts and not for others. these numbers are of one of the categories and how can i remove them.

last option would be that i will hide the numbers by adding text.

[Brett_Bleess]

I believe the QVW is going to be necessary to look into things further, as the issue likely is in the data model or something, but very difficult to troubleshoot without the application, so if you still need assistance, that is what I would recommend.  You can use Settings\Document Properties\Scrambling tab in the Desktop client to scramble any sensitive fields before posting too.

Regards,
Brett