Skip to main content

Hi Experts,

 

I have one 30 years weather dataset, include temperature, precipitation.

Then I build a sheet to find out the Max Precipitation for Each month in the 30 years.

Then I want to have tooptip in this sheet so I can check which is the exact date(may have more then 1 dates).

In that tooltip sheet I have the all the dates, I want to filter the sheet with Month(dates) and Precipitation bigger then Max Precipitation of that Month.

I don't know how to achieve filter the tooltip with Precipitation bigger then Max Precipitation of that Month.

Any suggestion to try?

 

Thanks.

How to filter the tooltip view with measure value?

截屏2020-09-24_00-24-30

截屏2020-09-24_00-23-22

截屏2020-09-24_00-24-05

3 answers
0/9000