Max of Year - Visual Level Filter Selection

[rhcentennialh]

I am trying to find out how i can get the "Max of" selection back in my Visual Level Filters for a data referencing Years. I was able to accomplish this earlier in the year but cant remember how i did this.

Currently i am looking at this (Below) and am unable to recreate what i did at the beginning of the year. 

I need to make it be "Max of Encounter Date - Year" so my filter and visuals will work properly

Any help would be greatly appreciated

[v-xicai · Accepted solution]

Hi @rhcentennialh ,

You may get this "Max of " setting like below in Format pane.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnthonyTilley]

Given the images you have posted the Max of year is a calculated colunm or measure that is then being filtered the MAX included in the name can only be because you have a colunm called max of year.or a measure called max of year 

i would guess that in one of your tables yeah have someting along the lines of Max of year = MAX([YEAR])

would need to no exactly what your trying to achive and some sample data along with a model in order to help any further