Bar chart showing null values (need global solution)
That's what I have
What i need:
I am using local solution, adding "+ SUM({1}0)" to a Chart formula, but is there a global solution? Otherwise I would have to redo each master formula in my project, which I don't want to do.
This is because the other dimensions don't exist in the data. An easy way would be to add them in. I can't understand your data (language), but if you are looking at months, then add a new table that just has 12 months and associate it with the data, this will then help you fill the gaps. You could also look at creating a master calendar, there are lots of threads on this topic.
