2 Replies Latest reply on Mar 5, 2018 11:46 AM by Wojciech Swiecicki

    Hide close to 0 values on a bar chart <-0.01;0.01> with two measures

    Wojciech Swiecicki

      Hi All,

      I have a bar chart as per below consisiting of two measures.

      What calculated fields and functions should be used in order to ahcieve the following effect:

      - If there are close to null values on green bars, they should be hidden while blue should be seen if they are out of the range <-0.01;0.01>

      - If there are close to null values on blue bars, they should be hidden while green should be seen if they are out of the range <-0.01;0.01>

      - If green and blue bars are in the range to hide which means <-0.01;0.01> they should be hidden

      - if green and blue bars are out of range to hide, they should be seen on the bar

      I was trying to create calculated boolean fields separate for every measure, but graph was hiding the whole bar - in case green or blue was in the range.

      Thanks for your help.

       

      Yellow highlighted values and bars would like to hide while others to be visible...

       

      File Attached below files in case twbx was not including source data.

      I'm new to Tableau and still learning.