Forum Discussion
Solved
using max column value as filter in scatter chart
Hello, I have data from following URL: https://fingertips.phe.org.uk/api/all_data/csv/by_indicator_id?indicator_ids=811%2C%2022001%2C%2030301&child_area_type_id=402&parent_area_type_id=6 The 3 dat...
It would help if you could show us the structure of the dataset.
However, try creating a measure along the lines of:Filter year = CALCULATE (MAX(Table[Time period sortable]), ALL(Table[Time period sortable)))
Add the Timeperiod sortable field to the filter pane for each visual. In the dropdown, select TopN and set the value to greater or equal to 1
Thanks PaulDBrown , worked perfectly. Jon