Forum Discussion

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
10 years ago
Solved

Dynamic change in X Axis

Hi All, 

Thanks Advanced !!!

 

Here i explain my Doubt and Question please help .

 

Goal : Create Line chart, [ with Month wise sales ]

 

Prob is :

 

I have slicer with month, when i have select single month in slicer , i want to show in X-Axis Week instead of Month.

 

Is it Possible ?

Is there any way to create calculated field ?

 

 

Am waiting  :smileysad: :smileysad: :smileysad: :smileysad: :smileysad:

 

@ankitpatira

Sean

Anonymous

Anonymous

 

Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi Baskar,

     

    Based on my research, the line chart X-axis value can't be changed based on the number of checked values in a slicer. So I'm afraid your requirement can't be achieved currently.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

3 Replies

  • waltheed's avatar
    waltheed
    Icon for Impactful Individual rankImpactful Individual
    10 years ago

    Hi Baskar,

     

    You can do something like that...

     

    If you create a hierarchy in your date dimension table (e.g. year - month - week)  you can use the drilldown option of the chart to get to the week level.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hi waltheed if I use pre calculated Avg. then do you  have any idea how it is possible thru drill down weekly.

       

        

       

       

       

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    10 years ago

    Hi Baskar,

     

    Based on my research, the line chart X-axis value can't be changed based on the number of checked values in a slicer. So I'm afraid your requirement can't be achieved currently.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu