Filter visual without filtering data

[Anonymous]

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?

[v-cherch-msft]

Hi @Anonymous

It seems you may have a look at this blog. Sample data and expected output will be helpful to provide an accurate solution.

How to Get Your Question Answered Quickly

Regards,

Cherie

[Anonymous]

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]

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

[Anonymous]

Thanks again @v-cherch-msft

When I use the drill down, I want to drill down on the current year data, and when I do that, I can't get the I can use the past 3 years to create an average line as the data gets filtered.

In the above photo, once I drilled into the current month, the dashed average line stops working.

It's quite late for me now, I'll try and make a more detailed example of what I'm hoping to achieve in the morning.