Forum Discussion
roma
Advocate II
Advocate IIDynamic change axis with the slicer value
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. Plea...
v-diye-msft
Community Support
Community SupportHi 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.
romaAdvocate II
Advocate IIHi 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