Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to have chart axis to show only data value

I have sales qty of 10,30,50 as my values for my dimension region. I want my bar chart to show only those values in Y axis.

Currently Y axis shows data points from 10 to 50.

Sample Data:

Region, SalesQty

    FL, 10

    GA, 30

    CA, 50

    NY, 10

    VT, 30

5 Replies
el_aprendiz111
Specialist
Specialist

Hi,

whi.png

Not applicable
Author

Hi ,

i changed the color but it doesnt hide the values 20 & 40 from Y axis.

i have attached the desired output i am looking for.

output sample.jpg

vishsaggi
Champion III
Champion III

Check this may be?

Expr in Background color.

Not applicable
Author

sorry i couldnt open the qvw, what expression do you advise for me to add to background color of expression?

vishsaggi
Champion III
Champion III

= IF(Match(Region, 'FL','NY'), White())