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!