Forum Discussion

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