3 Replies Latest reply on Mar 31, 2017 5:05 AM by Wahbi CHEBBI

    Align axis of two bar charts showing the same content with different options of the same filter

    Verena Linder

      Hi everybody,

       

      my dashboard should show a comparison of two years.

      Both years can be selected with a single value filter.

       

      I created the same bar chart for both years.

      The cost axis of these charts should have the same length but at the same time be dynamically to the values.

       

      I tried to create a reference line for the charts which shows the maximal cost value among all categories and both years.

      But as the filter is applied to the whole sheet the reference line will only show the maximum of the respective year.

       

      It would be great if someone can help me with this.

       

      Thanks a lot

      Verena