Dynamic x-axis while live connecting to SSAS

[SpikeSpiegel_3]

Is there any way to have a dynamic x-axis while connecting to ssas ? Because new parameter -> Fields does not work while live connecting, only works with import. 

I need a way to have a slicer that changes x-axis to year, month & day based on the user's selection. Is that applicable or can be done in any way (measure, etc) ?

[v-tianyich-msft]

Hi @SpikeSpiegel_3 ,

I think the easiest way to do this would be to change the timetable hierarchy to year, month and day. Then drill it down.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[SpikeSpiegel_3]

The point is that I need to use a slicer to show the data yearly, monthly or daily, so I cannot do it in this way.