Forum Discussion

nirvana_moksh's avatar
nirvana_moksh
Impactful Individual
7 years ago
Solved

Dynamic Date Axis

Hello All,

 

So I have a working solution for dynamic Column Series which is fed by a selection of a slicer and likewise, I have a dynamic selection for Column Values for a Stacked Bar chart. What I am trying to achieve is a dynamic Shared Axis too for Quarter and Month. I have two calculated columns -

 

For Quarter the values are - 2017-Q1, 2017-Q2 and so forth

For Month the values are - 2017- January,  2017-February and so forth 

 

For my Dynamic Date Selection I created a Table with two Values - Quarterly and Monthly and I created another slicer for this and the final value that was to be dynamic for the Shared Axis is something like TIme Intelligence =  SWITCH(SELECTEDVALUE('TIME TABLE'[TIME]),"QUARTERLY",VALUES('Main Table'[Quarterly Date])) 

 

but this fails as the above measure returns more than one value which is what I want but it errors out. Is this possible to do?

 

 

Thank You