Forum Discussion
pbimhkc
3 years agoFrequent Visitor
Changing date look back when using field parameters?
I have a stacked column chart that is summing an account balance on the y-axis with the date as the x-axis. I am using field parameters with both axes, with the x-axis having a toggle to group the ac...
amitchandak
3 years agoSuper User
pbimhkc , for that you have to switch measure with the axis
refer this example
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
But if select a date you can not get more than that on axis for that slicer needs to be on independent date table
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Deal with Period
https://medium.com/chandakamit/power-bi-when-i-felt-lazy-and-i-needed-too-many-measures-ed8de20d9f79