Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamic X Axis based on date slicer

I have a stacked column chart where the x axis is a list of dates. I also have a slicer for that same value that filters the other visuals based on that date. Is there a way to set the x axis of the ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , for that the slicer needs to be on an independent date table

 


//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] <=_max))

 

 

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI