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

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)