Dynamic Date Axis

[nirvana_moksh]

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

[Anonymous · Accepted solution]

Hi @nirvana_moksh,

I'd like to suggest you take a look at following blog, it may suitable for your requirement:

Dynamic Attributes In A Power BI Report

Regards,

Xiaoxin Sheng