5 Replies Latest reply on Jan 24, 2018 4:12 AM by MANOJ PRABHAKAR

    Change date axis based on a parameter

    Mary Brauch

      I have a chart that shows sales over time. I have 3 sales measures (which I cannot change) that are current sales, QTD sales, and YTD sales. I have successfully created a parameter and a calculated field that pick the right measure depending on if the user selects current, QTD or YTD.

       

      The problem:

      My x-axis (date field) doesn't change to reflect the time period. Is it possible to have the x-axis only show month when current, quarters when QTD and years when YTD? Can I do this the same way as I did for my measure if I create custom date fields?

       

      Thanks in advance!