Forum Discussion

aortuno's avatar
aortuno
Frequent Visitor
8 years ago
Solved

Always show the same x-axis values in the same order.

I'm putting together a dashboard that has two bar charts, they each display different measures for the same items.


Item A, Item 2 and Item 3.

 

Some days I refresh the data and whichever Item has a value of zero disappears from the X axis.

 

What I want is for the bar chart to always show the same values in the x-axis in the same order, even if sometimes some of them are zero and display no bar. 


Is that possible? 


Thanks!

  • aortuno,

     

    In the field options on your chart, select your axis and check "Show items with no data." That should give you what you need.

     

2 Replies

  • RMDNA's avatar
    RMDNA
    Icon for Solution Sage rankSolution Sage

    aortuno,

     

    In the field options on your chart, select your axis and check "Show items with no data." That should give you what you need.