Chart - hide lines with 0 values

    Chart - hide lines with 0 values


    in Excel I can add diagrams and say that lines that have only 0 values should not be displayed.
    Is there a way to do this in jedox? I cannot find an option like that.
    I have diagrams that refer to dynaranges. The dynarange in my sheet hides all lines that have no values for the chosen period via excel hide function. But in the diagramm the dimensions are all listed and dimensions without values for this period should not be shown...
    Any ideas hwo to solve this?

    try to use as source for your charts not fix ranges (e.g. "A1:B10") but named cells refering to dynamic ranges.

    the OFFSET function combined with the PALO.SUBSETSIZE one are good candidates to achieve this.

    Post hoc, non est propter hoc