Forum Discussion

claireberry's avatar
claireberry
Icon for Helper I rankHelper I
1 year ago

This picture is generated using the sample data you used. I just covered the bar with a card so you can see what I ultimately want to achieve. The point is not letting the viewer see that "a" has 5 counts anywhere in the chart. Thank you. 

  • claireberry's avatar
    claireberry
    Icon for Helper I rankHelper I
    1 year ago

    Yes, this is exactly what I want. Can you let me know what the settings are to achieve that? Mainly, how do you get the "S" to appear? Thank you

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      1 year ago

      claireberry 

      I created two measures

       

      Measure =
      VAR _sum=sum('Table'[Column2])
      return if(_sum>=0 && _sum<10,0,_sum)
       
      this measure to display 0 if the value is between 0 to 10
       
      measure2 =
      IF(
          [Measure]=0,
          "S",
          FORMAT([Measure],"#.##")
      )
       
      this measure will be added to detailed to display S instead of 0
       
      • claireberry's avatar
        claireberry
        Icon for Helper I rankHelper I
        1 year ago

        Hi ryan_mayu

        Thank so much for the V3. Can you please elaborate on why in the solution V3 isn't showing the blanks in the gender legend? I tried to implement the solution in my set of data, it shows blanks in the gender in the bar graph. thank you

  • claireberry's avatar
    claireberry
    Icon for Helper I rankHelper I
    1 year ago

    Sorry, it didn't completely work for me. I get the above error message when I put measure2 in the Detail -> Data slot. So It couldn't show the "S"