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 se...
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

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.