Dynamic change axis with the slicer value

[roma]

Hi Team,

I have a requirement where I have 2 date slicer as start date and end date.

In the graph I want to dynamically change X-axis of the graph based on the selected start and end date.

Please let me know the solution for this. 

[v-diye-msft]

Hi @roma 

I'd suggest you use one slicer to select the date range :

Then add the calculated column as X-axis:

Column = FORMAT([Date].[Month],"MMM")&"-"&"FCT"

Final outputs:

Pbix attached.

[roma]

Hi @v-diye-msft ,

Actually the requirement is that, All the months should be there in x-axis and only those months which falls under the selected slicer months should be as "monthname-FCT".

Is there any way to achieve this?

[v-diye-msft]

Hi @roma 

Sorry for the late reply, it's not achievable as far as I know.

[amitchandak]

@roma , refer

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M

[roma]

@amitchandak 

My requirement is I have 2 slicer startdate and end date as

and I have a graph as 

So in this example the Xaxis should dynamically change as Jan Feb Mar Apr "May-FCT Jun-FCT Jul-FCT  Aug-FCT " Sep Oct Nov Dec(because slicer has startdate month as may and enddate month as aug)

Thus whichever month falls under those selection of startdate and enddate , those month should be concatenated as "FCT" rest should be as it is

Please help me to create this.

Thank you.