How to make months with no data populated "disappear"?
""Hi,
I am having the following scenario:
- I am displaying data from an Excel file in a simple bar chart. In the file, there is data populated only up to, say, the month of may.
- I want, however, to display dimension-axis-points for all months till December so that the diagram layout is m.o.l. static.
- Background: I have currently set the values to be displayed above the bars (checkbox) for further clarity and I have gridlines for the y-axis.
<=> The months in the future, where there is no data populated yet, should not have bars so that the user can easily spot where the data ends, so to speak.
- I could easily implement a formula for the bar colour to be white when the month is greater than a variable which I set beforehand (to 5 in this instance), but in that case, as it is, there would be a) the values floating in mid-air and b) the gridlines I have set would be interspersed by white.
Is there an alternative way of having the values displayed so that it doesn't interfere with the other settings or that I can set it to become white, thus invisible?
If your future months wont have data, there would be no bar generated and eventually that is invisible and only the axis would show you the months like , Jun, July....(without any bar) right? did i get you properly?
By the way, if you are talking about the color of the values on data point, that can be defined(Axes - >Expression axes ->Font.
You could add a test to your bar's expression for whether date is less than today. something like this:
sum({<TheDate={'<=Today()'}>} Sales)
Alternatively, if I am missing the point and you are just worried about your values on the data points flating in mid air, how about putting the values on the axis instead ?
