Forum Discussion

lrnt12's avatar
lrnt12
Frequent Visitor
7 years ago
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...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

Hi Laurent,

 

Maybe something like this?

 

Avg Temp Dynamic = 
 SWITCH(
    TRUE();
    SELECTEDVALUE('Calculation'[Calculation]) = "Hourly"; [Avg Temp Hourly];
    SELECTEDVALUE('Calculation'[Calculation]) = "Daily"; [Avg Temp Daily];
    SELECTEDVALUE('Calculation'[Calculation]) = "Weekly"; [Avg Temp Weekly]
 )

In this case I created a table with the different alternatives to choose between the calculations. Then I've created the different measures seperately for each calculation and just referenced them in this dynamic measure.

 

Hope this helps!