Forum Discussion
Solved
Creating Measure to switch between Daily, Weekly, Monthly, Yearly
Hello, I have temperature values coming every 15 minutes (two columns - value and time). Is it possible to create a measure that calculates the average Hourly, Daily, Weekly, Monthly and somehow i...
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.
Hi Pattem~ I will be happy if you tell me how I can create this table with that table. THank you so much.