Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Change the x-axis dynamically

Hello everyone,    I have a slicer for "Period Selection" (Yearly, Quarterly, Monthly, Weekly and Daily).   The x-axis on my charts need to change as per the selection made from the slicer as fol...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi Anonymous,

     

    Here is an other similar thread which has provided a valid solution to dynamically show X-axis dimension.

     

    Dynamic change in X Axis

     

    Best regards,
    Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    vanessafvg For some charts, I will, don't worry. The problem is, I need to reflect this Axis Dimension in several charts & KPI's as well. 

     

    I am also using the custom visual found here. So when the user selects Yearly, Quarterly, Monthly, etc, the Trend Axis in the KPI Indicator needs to also change accordingly.

     

    Any idea on how to do this?

     

    Thanks in advance.

     

    Kind regards,

    Yogesh

    • vanessafvg's avatar
      vanessafvg
      Community Champion
      9 years ago

      Anonymous please post screen shots it really hard to visualise what you saying without providing examples and then also of what you actually wanting it to look like

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        vanessafvg

         

        The column chart below uses a Date Hierarchy which enables the user to drill down Year->Quarter->Month->Week->Day. 

         

         

        However, for the KPI's below, you need to specify a Trend Axis. 

         

        By default I have used the column MonthInCalendar. However, this axis needs to be dynamic. In simple english:

        Trend Axis =

        IF Yearly OR Monthly THEN MonthInCalendar

        ELSE IF Quarterly THEN QuarterInCalendar 

        ELSE IF Daily THEN DateInCalendar

        ELSE MonthInCalendar (default)