Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filter visual without filtering data

Hi,

 

Im current graphing temperatures by region, and I want to show a month of daily averages and have a constant line of the 3 year average for that month. I have calculated my 3 year averages, but when I try to plot current with the 3 year average, and set an average line based on the 3 year average I get the following visual;

 

I tried using the visual filter and setting it to the last month but when I do it stops calculating the average line and the black line just sits in the visual, not changing when I change month or region;

 

Any ideas on how to tackle this?

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-cherch-msft,

      Thanks for the reply, I'll add a more detailed description and sample data/report.

      The data I have is temperature data for New Zealand for serval weather station across the country updated every hour for the past several years.

      I have another table of GXP's, grid exit points (nodes where electricity leaves the distribution grid and is then sent to residences and businesses), and each GXP is assigned a weather station.

       

       

      Another table I have assigns each GXP to one of 14 grid zones accross the country.

      Using this I have created a measure using a disconnect date table to calculate the 3 year average for a selected month by take the average for the same month from the previous 3 years. 

      So what I have so far this 3 year average for each month, and I want to use it as a constantline for each month, so I will have graphed each days actual temp with this constant line temp so as to compare variance.
      Crappy paint mock up.

       

      So I eventally want to be able to select a region and a month.

      I was think of adding an extra column to my temperature data that checks the month and weather station and then calculates an average for that month, but with 40ish stations and  and each month being different, Im not sure how I go about this.

      Heres a copy of the report currently:
      https://drive.google.com/open?id=10Q-dJUaazkWb6gfrhb-hUuZkLEUMA0Wx

      • v-cherch-msft's avatar
        v-cherch-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous

         

        I cannot fully understand it. It seems you may use drill down and date hierarchy for visual. Please check the visual on page 3. If it is not your case, please simplified the sample data and provide the expected output if you need a measure.

         

        Regards,

        Cherie