2 Replies Latest reply on Sep 13, 2018 4:39 PM by Henry Shum

    Drop Down Menu Flexibility and Replace Nulls with Blanks

    Henry  Shum

      Hello,

       

      Attached are screenshots of my data and my workbook. For one numerical measure (Volume of Industrial Waste Water Discharged), I have data for the years 2012-2016. For the other measures, I only have data for the years 2013-2016. A measure can be viewed on a map of China by selecting it from the drop down menu. The year of the data can be changed by adjusting the slide bar.

       

      Is there a way to change the year filter such that the year slide bar shows the years 2012-2016 when I view that one particular measure, but the year slide bar only shows the years 2013-2016 when I view any other measure?

       

      Also, I have a number of numerical measures with null values in the data source that I would like to be replaced with blanks. Is there a quick way to do that? If not, is there a tedious way to do that?

       

      Thanks in advance!