6 Replies Latest reply on Sep 12, 2019 10:09 AM by Tainá Fernanda Carlos dos Santos de Moraes

    How to dynamically change the X axis?

    Robbie Lowie

      I have data in this format:

       

       

      This is how my chart currently looks like:

       

      When I change the parameter to quarter, I do not want to see 'Jan', 'April','July' and 'October'. Instead, I want to see something like this:

       

      Similarly, when I select 'Year' as the parameter, I only want to see the years (2016,2017 and 2018).

       

      How do I go about changing the x axis dynamically upon changing the parameter value?

       

      I've attached my workbook here. Thanks!