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

 

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)

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    vanessafvg I was looking at those 2 solutions some minutes ago :smileyhappy:

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      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

        Hi v-yulgu-msft

         

        Many thanks for your reply. I will give it a try.

         

        Kind regards,

        Yogesh