Forum Discussion
Filter visual without filtering data
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
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
- Anonymous7 years agoNot applicable
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.