Forum Discussion
Creating Measure to switch between Daily, Weekly, Monthly, Yearly
So you would like to have the x-axis to change depending on the value chosen in the slicer? As far as I know a measure cannot be set on the axis.
One solution could be using bookmarks instead. Create the four charts for each time period above eachother and use buttons assigned with bookmarks to toggle between the charts.
lrnt12 Please try using SWITCH and SELECTEDVALUE funtions...
Sample data and expected output will be helpful to provide an accurate solution.
Thanks for the reply.
My data looks like this. Value and Datetime field is what I pull from the source.
The expected output should be a slicer that would control the line chart. When I select Daily, I should see the average value for each day.
Basically, instead of having to drill up and down on the line chart, I'd like to control this with a slicer.
I have tried using SWITCH and SELECTEDVALUE, but it doesn't seem to work. Or perhaps I haven't used it right.
Thanks,
Laurent
So you would like to have the x-axis to change depending on the value chosen in the slicer? As far as I know a measure cannot be set on the axis.
One solution could be using bookmarks instead. Create the four charts for each time period above eachother and use buttons assigned with bookmarks to toggle between the charts.
Anonymous ... thinking outside the box, huh? Can't belive I didn't even think about it. Thanks !!
But I want to interact with the whole report . Then What I can do, for this case.?